aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/cases/adapters/postgresql
Commit message (Collapse)AuthorAgeFilesLines
* 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
| |
* | can create hstore records via AR APIAaron Patterson2011-12-201-0/+7
| |
* | multiple key / values workAaron Patterson2011-12-201-0/+6
| |
* | PostgreSQL hstore types are automatically deserialized from the database.Aaron Patterson2011-12-201-0/+16
| |
* | pg columns should understand the hstore typeAaron Patterson2011-12-201-0/+24
| |
* | Add missing requireJon Leighton2011-12-031-0/+2
| |
* | Avoid postgres 9.X syntaxJon Leighton2011-12-031-1/+5
| |
* | Deprecate set_table_name in favour of self.table_name= or defining your own ↵Jon Leighton2011-11-292-6/+6
| | | | | | | | method.
* | add the query to AR::Relation#explain outputXavier Noria2011-11-251-0/+3
|/ | | | | | | Rationale: this is more readable if serveral queries are involved in one call. Also, it will be possible to let AR log EXPLAINs automatically in production mode, where queries are not even around.
* fixing tests on PGAaron Patterson2011-11-161-1/+1
|
* Merge pull request #3521 from ↵Aaron Patterson2011-11-061-0/+4
| | | | | | nulogy/fix_postgres_adapter_to_handle_spaces_between_schemas Fix postgres adapter to handle spaces between schemas
* implements AR::Relation#explainXavier Noria2011-11-051-0/+25
| | | | | | | | | | | | | | | | | | | This is a first implementation, EXPLAIN is highly dependent on the database and I have made some compromises. On one hand, the method allows you to run the most common EXPLAIN and that's it. If you want EXPLAIN ANALYZE in PostgreSQL you need to do it by hand. On the other hand, I've tried to construct a string as close as possible to the ones built by the respective shells. The rationale is that IMO the user should feel at home with the output and recognize it at first sight. Per database. I don't know whether this implementation is going to work well. Let's see whether people like it.