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

From hubert depesz lubaczewski
Subject Re: How to trace client sql requests?
Date
Msg-id 20090710201027.GA18744@depesz.com
Whole thread Raw
In response to Re: How to trace client sql requests?  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
On Fri, Jul 10, 2009 at 03:45:35PM -0400, James B. Byrne wrote:
> I believe that this is what I want to examine.  Is there a server
> side technique that I can use which will tell me what data this
> statement returned or if it found nothing?

not really, sorry.

> In any case, I see the INSERTS and I can find NO DELETES at all.  Is
> there any other way to remove some or all data from a table?

truncate. but first simple question - did you commit the inserts?

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: "Scot Kreienkamp"
Date:
Subject: Idle in transaction help
Next
From: Peter Hunsberger
Date:
Subject: Using Postgres to store genetic data