Larry Rosenman wrote: > On Tue, 2002-08-27 at 15:54, Bruce Momjian wrote: > > > > I had an idea on this. It seems pretty pointless to show a query error > > without a query, but some queries are very large. > > > > How about if we print only the first 80 characters of the query, with > > newlines, tabs, and spaces reduced to a single space, and send that as > > LOG to the server logs. That would give people enough context, and > > prevent us from having another GUC variable. > Not necessarily giving enough context. I know I've had program > generated query's that were syntactically invalid WAY after the 80th > character. > > If you print ANY of the query, you should print all of it. Look at the > code in elog.c that does the syslog splitting.
But we should have some default to print some of the query, because right now we print none of it. I am not saying it is perfect, but it is better than what we have, and is a reasonable default. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
