| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bryce Nesbitt <bryce2(at)obviously(dot)com> |
| Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: SQL Statement Missing From Log |
| Date: | 2008-10-27 12:15:20 |
| Message-ID: | 14138.1225109720@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Bryce Nesbitt <bryce2(at)obviously(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Peters | 2008-10-27 16:25:37 | How to hand over array as variable in plpgsql function? |
| Previous Message | Devil™ Dhuvader | 2008-10-26 18:22:15 | how to sum entries from the last entry to some entry in between dynamically? |