Re: How to trace client sql requests? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: How to trace client sql requests?
Date
Msg-id 215D5260-3D98-4CFF-A5BA-50C7A8504E3A@solfertje.student.utwente.nl
Whole thread Raw
In response to How to trace client sql requests?  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
On Jul 10, 2009, at 7:38 PM, James B. Byrne wrote:

> I have a situation with a Rails project where test data in
> mysteriously "disappearing" in the middle of a test run.  I would
> like to see the exact SQL of all client requests issued against a
> single table during a fixed time span.


Are you sure you're looking at that data from the same connection, or
if not, that the inserts get committed? I've seen data "disappear" if
people forgot they were in a transaction block and didn't commit at
the end.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4a58614910131561119940!



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Best practices to WorkFlow design?
Next
From: Niederland
Date:
Subject: Re: Postgres 8.4 literal escaping