CSN wrote: > 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. Sure, Does your version have log_min_error_statement? If so, just set it to 'error' in postgresql.conf, pg_ctl reload, and you should see the statements. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
