aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
...
* PostgreSQL: last_insert_id uses select_value rather than using ↵Jeremy Kemper2005-11-131-2/+2
| | | | | | @connection.exec directly. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2998 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r4331@asus: jeremy | 2005-11-12 17:03:45 -0800Jeremy Kemper2005-11-131-2/+2
| | | | | | | | | PostgreSQL: default_sequence_name falls back to 'id' pk if both the given pk and discovered pk are nil. r4336@asus: jeremy | 2005-11-12 22:31:39 -0800 PostgreSQL: correct the sequence discovery fallback query. References #2594. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2994 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r4325@asus: jeremy | 2005-11-12 03:57:46 -0800Jeremy Kemper2005-11-121-15/+42
| | | | | | | PostgreSQL: correctly discover custom primary key sequences. PostgreSQL: smarter sequence name defaults, stricter last_insert_id, warn on pk without sequence. Base.reset_sequence_name analogous to reset_table_name (mostly useful for testing). Base.define_attr_method allows nil values. References #2594. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2985 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Map AR time to PostgreSQL TIME. Closes #2575.Jeremy Kemper2005-10-231-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2712 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Correct PostgreSQL primary key sequence detection. #2507Jeremy Kemper2005-10-181-13/+20
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2680 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r3616@asus: jeremy | 2005-09-26 23:09:28 -0700Jeremy Kemper2005-10-161-4/+36
| | | | | | | | | | | | | | | | | | | | | | | Ticket 2292 - Sequences, schemas, and fixtures r3917@asus: jeremy | 2005-10-15 10:43:24 -0700 fix pk assert r3918@asus: jeremy | 2005-10-15 10:46:52 -0700 rework query cache connection= override r3919@asus: jeremy | 2005-10-15 10:47:45 -0700 correct fixtures usage r3920@asus: jeremy | 2005-10-15 10:53:23 -0700 correct attr assignment r3921@asus: jeremy | 2005-10-15 12:59:10 -0700 sequences r3922@asus: jeremy | 2005-10-15 16:36:09 -0700 reset fixtures work with sequences r3951@asus: jeremy | 2005-10-15 23:23:12 -0700 cut down excess features r3952@asus: jeremy | 2005-10-15 23:40:30 -0700 don't test for PostgreSQL specifically git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2639 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Back out of [2548].Marcel Molina2005-10-141-18/+18
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2581 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Optimize postgresql selects.Marcel Molina2005-10-131-18/+18
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2548 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* PostgreSQL returns the path type wrapped in quotes.Marcel Molina2005-10-091-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2499 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add geometric type for postgresql adapter. Closes #2233.Marcel Molina2005-10-091-0/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2498 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add rename_table to mysql, sqlite and postgres adapters for use in migrationsTobias Lütke2005-10-061-0/+4
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2477 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Get rid of old symbolize_strings_in_hash.Jeremy Kemper2005-09-301-9/+7
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2427 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Ticket 2256 - Recognize PostgreSQL NOW() default as equivalent to ↵Jeremy Kemper2005-09-271-1/+1
| | | | | | CURRENT_TIMESTAMP/CURRENT_DATE git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2378 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r3590@asus: jeremy | 2005-09-26 17:00:53 -0700Jeremy Kemper2005-09-261-7/+43
| | | | | | | Correct and optimize PostgreSQL bytea escaping. This is a blend of four patches, each providing a bit to the solution. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2347 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Refactored the AbstractAdapter to be a lot less scary. Cleaned up the docs ↵David Heinemeier Hansson2005-09-251-73/+80
| | | | | | and style for the OSS adapters git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2339 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fix migrations with PG 7.x.Scott Barron2005-09-251-0/+13
| | | | | | | Closes #1850 git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2332 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Allow the postgresql adapter to work with the SchemaDumper.Jamis Buck2005-09-231-4/+48
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2317 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Post the postgresql adapter (and hopefully other adapters) pass all testsJamis Buck2005-09-231-2/+8
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2316 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made Oracle a first-class connection adapter by adhering closer to idiomatic ↵David Heinemeier Hansson2005-07-241-1/+1
| | | | | | Oracle style #1798 [The Gang of Oracles] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1912 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made default changes work in both postgresql and mysql #1612 [Tobias Luetke]David Heinemeier Hansson2005-07-051-4/+7
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1703 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Sugared up migrations with even more bling #1609 [Tobias Luekte]David Heinemeier Hansson2005-07-051-3/+15
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1697 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added new Migrations framework for describing schema transformations in a ↵David Heinemeier Hansson2005-07-041-0/+21
| | | | | | way that can be easily applied across multiple databases #1604 [Tobias Luetke] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1672 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1278@iwill: jeremy | 2005-06-12 05:11:48 -0700Jeremy Kemper2005-06-121-50/+62
| | | | | | | | | | | | | | | | | | | | | Branch for PostgreSQL schema. Ticket #827. r1281@iwill: jeremy | 2005-06-12 19:06:43 -0700 remove search_path from PostgreSQL db definition r1282@iwill: jeremy | 2005-06-12 19:07:50 -0700 Rakefile support for database-specific tests. r1283@iwill: jeremy | 2005-06-12 19:10:18 -0700 Add schema_search_path attribute to PostgreSQL adapter. Replace table_structure with column_definitions which finds the given table_name in the schema search path. r1284@iwill: jeremy | 2005-06-12 19:12:10 -0700 Unit test PostgreSQL schema search path. r1285@iwill: jeremy | 2005-06-12 19:12:20 -0700 Changelog entry. r1286@iwill: jeremy | 2005-06-12 20:08:20 -0700 Don't try to quote schema names. Include a reference to the PostgreSQL schema docs. r1287@iwill: jeremy | 2005-06-12 20:16:07 -0700 SchemasTest -> SchemaTest git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1407 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Return PostgreSQL columns in the order they are declared #1374 ↵Jeremy Kemper2005-06-121-18/+17
| | | | | | (perlguy@gmail.com). Unit test column order, adapter housekeeping, simplify users of columns_hash. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1405 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added encoding and min_messages options for PostgreSQL #1205 [shugo]David Heinemeier Hansson2005-04-301-0/+6
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1255 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added support for timestamp with time zone in PostgreSQL #560 [Scott Barron]David Heinemeier Hansson2005-03-061-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@858 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that postgresql adapter would fails when reading bytea fields with ↵David Heinemeier Hansson2005-03-061-2/+2
| | | | | | null value #771 [rodrigo k] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@849 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added documentation for database adapters to visible RDocDavid Heinemeier Hansson2005-02-231-2/+12
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@771 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added option :schema_order to the PostgreSQL adapter to support the use of ↵David Heinemeier Hansson2005-02-231-1/+7
| | | | | | multiple schemas per database #697 [YuriSchimke] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@755 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added automatic dropping/creating of test tables for running the unit tests ↵David Heinemeier Hansson2005-02-201-0/+4
| | | | | | on all databases #587 [adelle@bullet.net.au] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@719 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed binary support for PostgreSQL #444 [alex@byzantine.no]David Heinemeier Hansson2005-01-151-1/+29
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@410 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Changed the interface on AbstractAdapter to require that adapters return the ↵David Heinemeier Hansson2004-12-191-2/+7
| | | | | | number of affected rows on delete and update operations. Added that Base.update_all and Base.delete_all return an integer of the number of affected rows #341 git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@228 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* InitialDavid Heinemeier Hansson2004-11-241-0/+170
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4 5ecf4fe2-1ee6-0310-87b1-e25e094e27de