Thread: how to capture query?

how to capture query?

From

Mark

Date:

11 February 2005, 15:54:09

Hi,
I'm getting some errors in log file saying "invalid character at
position
#20..." I know that this is most likely that query is wrong.

Is it possible to capture all queries that get send or at least the
invalid queries?

I'm using postgresql 7.4.3 on Red Hat 9

Thanks,
Mark



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com

Re: how to capture query?

From

Brad Nicholson

Date:

11 February 2005, 16:10:57

To log all queries - in your postgresql.conf file, set the following:
log_statement = true

Mark wrote:

>Hi,
>I'm getting some errors in log file saying "invalid character at
>position
>#20..." I know that this is most likely that query is wrong.
>
>Is it possible to capture all queries that get send or at least the
>invalid queries?
>
>I'm using postgresql 7.4.3 on Red Hat 9
>
>Thanks,
>Mark
>
>
>
>__________________________________
>Do you Yahoo!?
>The all-new My Yahoo! - What will yours do?
>http://my.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>


--
Brad Nicholson  416-673-4106    bnichols@ca.afilias.info
Database Administrator, Afilias Canada Corp.

Re: how to capture query?

From

Yury Don

Date:

11 February 2005, 16:12:14

M> Hi,
M> I'm getting some errors in log file saying "invalid character at
M> position
M> #20..." I know that this is most likely that query is wrong.

M> Is it possible to capture all queries that get send or at least the
M> invalid queries?

M> I'm using postgresql 7.4.3 on Red Hat 9

M> Thanks,
M> Mark

In postgresql.conf write
log_min_error_statement = error

--
Best regards,
 Yury                            mailto:yura@vpcit.ru