Logging database and statement with errors

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging database and statement with errors
Date: 2004-04-06 21:57:36
Message-ID: 20040406215736.38652.qmail@web40609.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm getting a bunch of these in my log:

2003-11-22 21:00:00 ERROR: syntax error at or near
"s" at character 87

I think there might be an unescaped ' getting through.
Is there a way to have the database and statement show
up along with the error? log_statements appears to log
every statement.

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mboes 2004-04-06 22:16:53 timestamp precision with or without timezones
Previous Message wespvp 2004-04-06 21:37:36 Re: Cursors and Transactions, why?