Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Statement Missing From Log - Mailing list pgsql-sql

From Tom Lane
Subject Re: SQL Statement Missing From Log
Date
Msg-id 14138.1225109720@sss.pgh.pa.us
Whole thread Raw
In response to SQL Statement Missing From Log  (Bryce Nesbitt <bryce2@obviously.com>)
List pgsql-sql
Tree view 
Bryce Nesbitt <bryce2@obviously.com> writes:
> I'm getting a bunch of:

> 2008-10-25 14:36:59 PDT ERROR:  syntax error at or near "SET" at character 9
> 2008-10-25 14:36:59 PDT ERROR:  syntax error at or near "fetch" at
> character 9
> 2008-10-25 14:36:59 PDT ERROR:  current transaction is aborted, commands
> ignored until end of transaction block

> With no idea where the "SET" is coming from.   My logging configuration
> is as follows.  What am I doing wrong?  How can I get the full failing
> SQL statement?

log_min_error_statement needs to be ERROR or less.
        regards, tom lane

pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: SQL Statement Missing From Log
Next
From: "Jan Peters"
Date:
Subject: How to hand over array as variable in plpgsql function?