aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
* Merge pull request #3521 from ↵Aaron Patterson2011-11-061-2/+1
| | | | | | nulogy/fix_postgres_adapter_to_handle_spaces_between_schemas Fix postgres adapter to handle spaces between schemas
* implements AR::Relation#explainXavier Noria2011-11-051-1/+43
| | | | | | | | | | | | | | | | | | | 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.
* AR changes to support creating ordered (asc, desc) indexesVlad Jebelev2011-11-041-3/+13
|
* clear statement cache when tables are alteredAaron Patterson2011-10-271-0/+6
|
* Merge pull request #3258 from ileitch/3-1-stableAaron Patterson2011-10-201-1/+7
| | | | Postgres: Do not attempt to deallocate a statement if the connection is no longer active.
* reset prepared statement when schema changes imapact statement results. ↵Aaron Patterson2011-10-181-11/+43
| | | | fixes #3335
* Use the schema_search_path in prepared statements.Juan M. Cuello2011-10-051-3/+4
| | | | | To allow the use of prepared statements when changing schemas in postgres, the schema search path is added to the sql key.
* LRU should cache per process in postgresql. fixes #1339Aaron Patterson2011-09-071-10/+14
|
* fixing view queriesAaron Patterson2011-09-071-3/+5
|
* use the supplied bind valuesAaron Patterson2011-09-071-1/+1
|
* Merge commit 'refs/pull/2909/head' of https://github.com/rails/rails into rawrAaron Patterson2011-09-071-6/+4
| | | | | | * https://github.com/rails/rails: Postgresql adapter: added current_schema check for table_exists? Postgresql adapter: added current_schema check for table_exists?
* Database adapters use a statement pool.Aaron Patterson2011-09-061-5/+41
| | | | | | Database adapters use a statement pool for limiting the number of open prepared statments on the database. The limit defaults to 1000, but can be adjusted in your database config by changing 'statement_limit'.
* Merge pull request #2021 from dasch/more_postgres_utilsAaron Patterson2011-08-291-1/+3
|\ | | | | Make #extract_schema_and_table an instance method in Utils
| * Make #extract_schema_and_table an instance method in UtilsDaniel Schierbeck2011-07-091-1/+3
| | | | | | | | Also, move the utils test into its own test case.
* | Make it the responsibility of the connection to hold onto an ARel visitor ↵Jon Leighton2011-08-081-0/+4
| | | | | | | | for generating SQL. This improves the code architecture generally, and solves some problems with marshalling. Adapter authors please take note: you now need to define an Adapter.visitor_for method, but it degrades gracefully with a deprecation warning for now.
* | accept option for recreate db for postgres (same as mysql now)artemk2011-08-041-2/+4
|/
* Refactor PostgreSQLAdapter a bitDaniel Schierbeck2011-07-081-16/+18
| | | | | Move the private method #extract_schema_and_table into a separate Utils module so that it can be tested without resorting to #send.
* Improve ordering of multiple columns on postgresqlLucia Escanellas2011-06-241-1/+1
| | | | | * Only on postgresql, order("first asc, second asc") was invalid * Closes #1720
* Merge remote branch 'rails/master' into pg_schema_fuPaul Gallagher2011-06-191-2/+2
|\
| * Remove trailing whitespacesGuillermo Iguaran2011-06-121-2/+2
| |
* | Make PostgreSQL adapter view-compatiblePaul Gallagher2011-06-191-3/+5
| | | | | | * amongst other things, allows meta_search to run against view-backed models
* | make extract_schema_and_table a private methodPaul Gallagher2011-06-111-20/+17
| |
* | remove table quoting in primary_key methodPaul Gallagher2011-06-111-1/+1
| | | | | | * add/cleanup tests
* | apply private method indentation conventionPaul Gallagher2011-06-101-22/+22
| | | | | | * tidy test code and fix my typo
* | Improve PostgreSQL adapter schema-awarenessPaul Gallagher2011-06-101-25/+51
|/ | | | | | | * table_exists? scoped by schema search path unless schema is explicitly named. Added tests and doc to clarify the behaviour * extract_schema_and_table tests and implementation extended to cover all cases * primary_key does not ignore schema information * add current_schema and schema_exists? methods * more robust table referencing in insert_sql and sql_for_insert methods
* Revert "[activerecord][postgresql] verify if table has a schema(not ↵Jon Leighton2011-05-311-5/+6
| | | | | | public)". This caused a test breakage. See #1410 for details. This reverts commit c44418ea4e09cc81da47edbc9ac5f31c7e32c1b4.
* [activerecord][postgresql] verify if table has a schema(not public)Lucas Stephanou2011-05-271-6/+5
|
* find sequences with pg schemas properlyLucas Stephanou2011-05-271-4/+11
|
* Merge branch 'master' of git://github.com/lifo/docrailsXavier Noria2011-05-251-2/+2
|\ | | | | | | | | | | Conflicts: actionmailer/lib/action_mailer/base.rb activesupport/lib/active_support/core_ext/kernel/requires.rb
| * Remove extra white spaces on ActiveRecord docs.Sebastian Martinez2011-05-231-2/+2
| |
* | Removed AS core_ext/kernel/requires as it's not used and is bad practice.Josh Kalderimis2011-05-231-1/+0
|/
* on.upcase!Akira Matsuda2011-05-191-1/+1
|
* why not use JOIN statement for joining tables? (vol. 2)Akira Matsuda2011-05-181-21/+12
|
* remove unused table from FROM clauseAkira Matsuda2011-05-181-2/+0
| | | | pg_namespace has not been used since this commit 29b0707f07f148d98515125dab44b73cfdc0a3d4
* why not use JOIN statement for joining tables?Akira Matsuda2011-05-181-3/+3
|
* supporting infinity and -infinity for timestamps in PG. fixes #544Aaron Patterson2011-05-131-0/+13
|
* Merge branch 'master' of git://github.com/lifo/docrailsXavier Noria2011-05-011-3/+7
|\ | | | | | | | | Conflicts: railties/guides/source/contributing_to_ruby_on_rails.textile
| * Merge branch 'master' of github.com:lifo/docrailsDan Pickett2011-04-291-3/+7
| |\
| | * Fix #postgresql_version docsSebastian Martinez2011-04-221-1/+1
| | |
| | * Make this docs more consistent with the rest of the docs presentSebastian Martinez2011-04-221-1/+2
| | |
| | * Added docs for #rename_table on some adaptersSebastian Martinez2011-04-221-0/+3
| | |
| | * Merge branch 'master' of git://github.com/rails/railsXavier Noria2011-04-231-39/+36
| | |\
| | * | Added docs for #indexes on adaptersSebastian Martinez2011-04-221-1/+1
| | | |
* | | | using bind parameters for updatesAaron Patterson2011-04-301-0/+1
|/ / /
* | | convert query results to a list of listsAaron Patterson2011-04-291-2/+1
| | |
* | | requring pg ~> 0.11, so remove conditional code for supporting older ↵Aaron Patterson2011-04-291-56/+12
| | | | | | | | | | | | versions of the gem
* | | Make postgresql faster on development (thanks to @tapajos).José Valim2011-04-291-0/+8
| | |
* | | postgresql supports prepare statement deletesAaron Patterson2011-04-291-22/+31
| | |
* | | Merged pull request #310 from beanieboi/master.Aaron Patterson2011-04-261-1/+10
|\ \ \ | |_|/ |/| | Added support for tsvector datatype in postgres
| * | Added tsvector Datatype SupportBenjamin Fritsch2011-04-261-1/+10
| | | | | | | | | Applied Patch from https://rails.lighthouseapp.com/projects/8994/tickets/5577-suport-from-tsvector-data-type-in-postgresql
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-30 21:44:52 +0000