aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/cases/adapters/postgresql
Commit message (Collapse)AuthorAgeFilesLines
* Merge pull request #6245 from bogdan/bc_timestampRafael Mendonça França2012-11-211-0/+9
|\ | | | | Postgresql adapter: fix handling of BC timestamps
| * Fix postgresql adapter to handle bc timestamps correctlyBogdan Gusiev2012-11-211-0/+9
| |
* | Refactoring, testing and documenting pg_connection.distinctSemyon Perepelitsa2012-11-211-0/+29
|/
* Postgresql doesn't accepts limits on text columns.Victor Costan2012-11-201-0/+18
|
* Fix typo in inet and cidr savingMiguel Herranz2012-10-141-0/+13
|
* #7914 get default value when type uses schema nameArturo Pie2012-10-131-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | PostgreSQL adapter properly parses default values when using multiple schemas and domains. When using domains across schemas, PostgresSQL prefixes the type of the default value with the name of the schema where that type (or domain) is. For example, this query: ``` SELECT a.attname, d.adsrc FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = "defaults"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum; ``` could return something like "'<default_value>'::pg_catalog.text" or "(''<default_value>'::pg_catalog.text)::text" for the text columns with defaults. I modified the regexp used to parse this value so that it ignores anything between ':: and \b(?:character varying|bpchar|text), and it allows to have optional parens like in the above second example.
* Cleanup trailing whitespacesdfens2012-10-121-1/+1
|
* PostgreSQL, quote table names when fetching the primary key. Closes #5920Yves Senn2012-10-051-0/+4
|
* Moves column dump specific code to a module included in AbstractAdapterDan McClain2012-09-142-6/+104
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Having column related schema dumper code in the AbstractAdapter. The code remains the same, but by placing it in the AbstractAdapter, we can then overwrite it with Adapter specific methods that will help with Adapter specific data types. The goal of moving this code here is to create a new migration key for PostgreSQL's array type. Since any datatype can be an array, the goal is to have ':array => true' as a migration option, turning the datatype into an array. I've implemented this in postgres_ext, the syntax is shown here: https://github.com/dockyard/postgres_ext#arrays Adds array migration support Adds array_test.rb outlining the test cases for array data type Adds pg_array_parser to Gemfile for testing Adds pg_array_parser to postgresql_adapter (unused in this commit) Adds schema dump support for arrays Adds postgres array type casting support Updates changelog, adds note for inet and cidr support, which I forgot to add before Removing debugger, Adds pg_array_parser to JRuby platform Removes pg_array_parser requirement, creates ArrayParser module used by PostgreSQLAdapter
* postgres, map scaled intervals to string datatype (#7518)Yves Senn2012-09-061-1/+3
|
* Put the create_table block in a transaction.Rafael Mendonça França2012-09-051-2/+4
| | | | | This will solve the issue that abort the connection transaction when we skip the tests.
* ActiveRecord support to PostgreSQL 9.2 JSON typeDickson S. Guedes2012-09-051-0/+69
| | | | | | | | | This implements the support to encode/decode JSON data to/from database and creating columns of type JSON using a native type [1] supported by PostgreSQL from version 9.2. [1] http://www.postgresql.org/docs/9.2/static/datatype-json.html
* Modularize postgresql adapterKonstantin Shabanov2012-09-051-3/+0
|
* Fix only-once stub logic.Steve Jorgensen2012-08-081-1/+1
| | | | | Didn't fail the test because adapter#query happens to not call raw connection's #query, but don't want to count on that and have a fragile test.
* Fix just-plain-wrongness of psql auto-reconnect test.Steve Jorgensen2012-08-071-8/+9
| | | | | | Full test requiring manual intervention was fine, but w/ simulated disconnect, assertion was backward & still passing. Was several kinds of wrong.
* Stop being silly with formatting of method aliasing.Steve Jorgensen2012-07-161-3/+3
|
* Simulated & actual (manual/skipped) PostgreSQL auto-reconnection tests.Steve Jorgensen2012-07-161-0/+72
|
* Unify the collation API for the database adptersRafael Mendonça França2012-07-012-4/+4
|
* Support collate and ctype on the PostgreSQL.kennyj2012-06-292-0/+12
|
* Allow precision option for postgresql datetimesTony Schneider2012-06-221-0/+65
| | | | | | | | | | This patch addresses the difficulty of retrieving datetime fields. By default, the database holds a higher precision than the time as a String. This issue is discussed at length at the following links: - [#3519](https://github.com/rails/rails/issues/3519) - [#3520](https://github.com/rails/rails/issues/3520) Also, kudos to @mattscilipoti
* Change minimum (default) log level in PostgreSQL to warning.kennyj2012-06-181-0/+4
|
* Add uuid type support to PostgreSQL adapterKonstantin Shabanov2012-06-141-0/+15
|
* Fix logs name consistency.kennyj2012-05-191-0/+44
|
* Removes NetAddr dependencyDan McClain2012-05-081-3/+4
|
* Converts inet and cidr columns to NetAddr::CIDRDan Seaver2012-05-071-4/+6
|
* Adds migration and schema dump support for INET, CIDR, and MACADDRDan Seaver2012-05-051-3/+3
|
* Merge pull request #3713 from kf8a/masterAaron Patterson2012-05-041-0/+12
|\ | | | | postgresql adapter should quote not a number and infinity correctly for float columns
| * postgresql adapter handles quoting of not a number (NaN) and InfinitySven Bohm2011-11-211-0/+12
| |
* | Merge pull request #5698 from dougcole/support_postgresql_partitioningAaron Patterson2012-04-271-0/+31
|\ \ | | | | | | Support postgresql partitioning by making INSERT RETURNING optional
| * | refactor configuration of insert_returningDoug Cole2012-04-071-19/+15
| | |
| * | pick better names and add a little documentationDoug Cole2012-04-011-8/+8
| | |
| * | improve test coverageDoug Cole2012-03-311-0/+26
| | |
| * | add use_returning as a postgresql connection configDoug Cole2012-03-311-0/+9
| | |
* | | %s/find(:\(first\|last\|all\), \([^()]*\))/scoped(\2).\1/gcI amongst other ↵Jon Leighton2012-04-271-3/+3
| | | | | | | | | | | | things
* | | Always quote hstore keys and valuesRyan Fitzgerald2012-04-241-1/+9
|/ / | | | | | | | | | | | | escape_hstore uses quotation marks around keys and values only if it seems necessary. However, it currently breaks in the presence of some non-ASCII characters. Instead of trying to guess exactly which characters are safe, it seems better to always use quotes.
* | Fix GH #5430. A Payload name for schema_search_path should be SCHEMA.kennyj2012-03-151-0/+7
| |
* | Adds #create/drop_schema on the PostgreSQL Adapter.Travis Jeffery2012-03-071-2/+37
| |
* | Add #schema_names to PostgreSQL Adapter.Travis Jeffery2012-03-071-0/+4
| |
* | Remove NULLS FIRST/LAST. closes #5152kennyj2012-02-251-0/+5
| |
* | Restored ability to identify ID and Sequence from tables relying on a ↵William Lawson2012-02-201-3/+7
| | | | | | | | nonmatching sequence default value for PK.
* | Merge branch 'joelhoffman-postgres_schema_builder' into instance_readerAaron Patterson2012-02-101-8/+68
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * joelhoffman-postgres_schema_builder: Also support writing the hstore back to the database Hstore values are all strings string_to_hstore / hstore_to_string, serializing don't test schema where hstore not installed schema dumper tests for hstore Additional hstore tests, supporting null values, better compliance with postgres docs add hstore to postgres native types and defaults Conflicts: activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
| * | Also support writing the hstore back to the databaseJoel2012-02-081-0/+8
| | |
| * | string_to_hstore / hstore_to_string, serializingJoel2012-02-081-6/+6
| | |
| * | Additional hstore tests, supporting null values, better compliance with ↵Joel2012-02-081-7/+59
| | | | | | | | | | | | postgres docs
* | | Made schema dumper recognize partial indices' where statementsMarcelo Silveira2012-02-091-0/+6
| | |
* | | Added where option to add_index to support postgresql partial indicesMarcelo Silveira2012-02-091-0/+12
|/ / | | | | | | | | | | | | | | | | | | | | The `add_index` method now supports a `where` option that receives a string with the partial index criteria. add_index(:accounts, :code, :where => "active") Generates CREATE INDEX index_accounts_on_code ON accounts(code) WHERE active
* | Postgresql: add test case for setting custom libpq connection parametersLars Kanis2012-01-041-0/+15
| |
* | skip hstore tests on PG databases that do not have hstoreAaron Patterson2011-12-201-2/+8
| |
* | making sure updates workAaron Patterson2011-12-201-7/+13
| |
* | hstores can cycleAaron Patterson2011-12-201-2/+26
| |