Displaying 2 results from an estimated 2 matches for "exec_cache".
2011 Sep 13
4
Prepared statements and postgreSQL schemas
...t is executed many times no
matter if you changed the schema, i.e, the prepared statement is executed
ALWAYS for the same schema, the one set when the statement was prepared.
I migrated yesterday from 3.0 to 3.1 and ended up with all my new data
(INSERT operations) into the same schema.
''exec_cache'' method in postgresql_adapter.rb uses the sql string as the
cache key. Maybe we could include also the ''schema_search_path''.
I didn''t want to go into details here, but I could create an issue or a pull
request if this approach seems reasonably.
Juan
--
You re...
2011 Sep 18
9
Rails 3 and postgresql
I have a simple project created around a very, very simple database: one
main table packs with just three rows
Column | Type |
Modifiers
--------+-----------------------------+----------------------------------------------------
id | integer | not null default
nextval(''packs_id_seq''::regclass)
nombre | character