Re: Proposed GUC Variable

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposed GUC Variable
Date: 2002-08-23 06:46:50
Message-ID: GNELIHDDFBOCMGBFGEFOMENMCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> Quick hack while eating a sandwich.
>
> template1=# select * frum;
> ERROR: parser: parse error at or near "frum" at character 10
> ERROR QUERY: select * frum;
>
> Now, I did say quick hack. 'ERROR QUERY' isn't a new error level I just
> strcat() it to buf_msg in elog() if debug_print_error_query is
> true. Question: from Chris's request it doesn't sound like there is much
> use writing this to the client. Does everyone else feel the same way?
>
> If so, I'll patch it up and send off.

How about the ERROR occurs and is sent to client and logged. Then you do
another elog(LOG, querystring) sort of thing. That way you won't confuse
clients that are parsing the messages but those interested in the log text
can read it quite happily.

That'd be my preferred solution...

Thanks for working on this BTW gavin.

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Bertheau 2002-08-23 07:54:57 Re: Proposed GUC Variable
Previous Message Justin Clift 2002-08-23 06:34:47 Re: [HACKERS] Excellent DBMS Resource Site

Browse pgsql-patches by date

  From Date Subject
Next Message Markus Bertheau 2002-08-23 07:54:57 Re: Proposed GUC Variable
Previous Message Tom Lane 2002-08-23 05:43:08 Re: Point in time recovery 20020822_01_pitr.patch