Re: Obtain historial of query's - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: Obtain historial of query's
Date
Msg-id 200610031719.04598.achill@matrix.gatewaynet.com
Whole thread Raw
In response to Obtain historial of query's  ("Sistemas C.M.P." <sistemascmp@redynet4.com.ar>)
List pgsql-admin
Στις Τρίτη 03 Οκτώβριος 2006 16:59, ο/η Sistemas C.M.P. έγραψε:
> It's posible to obtain querys that user had sent in some date?
> because there are records that had been deleted strangely.   And I'd like
> to obtain an historial of sent query's from the users.

What does:
SHOW log_statement;
say?
if it is set to on, then you might stand a chance by examining your logs (if
not purged by some periodic task) for these strangely deleted rows.
What version of PgSQL do you run?
--
Achilleas Mantzios

pgsql-admin by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: [SQL Question] Selecting distinct rows having field value pairs on semantics
Next
From: lst_hoe01@kwsoft.de
Date:
Subject: Re: Please. Do cancel my subscription!!