On Jul 10, 2009, at 1:31 PM, James B. Byrne wrote:
On Fri, July 10, 2009 16:10, hubert depesz lubaczewski wrote:
truncate. but first simple question - did you commit the inserts?
But if it were done with truncate then I would see truncate in the
log file, yes?
Second, I am working with PG through an ORM called ActiveRecord,
part of the Rails framework. I do not see a COMMIT anywhere in the
log. Should I? This is a test run using the Rails test, actually
cucumber, environment. I know that they do some things differently
with DB connections in this environment but I believe that this is
limited to transactions and rollbacks.
The thing is that this problem only arises when testing the script
inside the test harness. In production it runs just fine. Further,
if I list the contents of the table from a call in the test harness
immediately prior to executing the script under test then the data
is there.
I'm not sure about cucumber but I'm fairly certain that the Rails test
runs don't commit their transactions. That means that if the test
that is not seeing the data is perhaps being run with a different db
connection from that that inserted the data then it won't see it.
Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
