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
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 |