Re: Debugging SQL queries

On 5/11/06, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> wrote:
> From my point of view, more important problem is that log doesn't help
> to find the query (in other words, log message doesn't show context)

Yes it does.. but it depends on your logging setup.

in psql:

test=# blah;
ERROR: syntax error at or near "blah" at character 1

my log shows:

... [9-1] LOG: statement: blah;
... [10-1] ERROR: syntax error at or near "blah" at character 1

Do you have:

log_statement = true

in your postgresql.conf ?

--
Postgresql & php tutorials
http://www.designmagick.com/