SQL Statement Missing From Log

From: Bryce Nesbitt <bryce2(at)obviously(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: SQL Statement Missing From Log
Date: 2008-10-25 21:42:32
Message-ID: 490392C8.4090306@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Helpful People,

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?

# grep "log_" postgresql.conf | grep -v "^#"
log_min_messages = notice # =notice Values, in order of
decreasing detail:
log_error_verbosity = verbose # =default terse, default, or
verbose messages
log_min_duration_statement = 250 # -1 is disabled, 0 logs all
statements
log_line_prefix = '%t ' # Special values:
debug_pretty_print =on # = off

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Devil™ Dhuvader 2008-10-26 18:22:15 how to sum entries from the last entry to some entry in between dynamically?
Previous Message Harold A. Giménez Ch. 2008-10-25 15:36:08 Re: Truncate on pg_dump / pg_restore