[Fwd: Re: How to trace client sql requests?]

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 do not know what is going on.

--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3

--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3