Re: defer statement logging until after parse

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: defer statement logging until after parse
Date: 2004-03-12 20:22:58
Message-ID: 200403122022.i2CKMwL28614@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Andrew Dunstan wrote:
> >> It does print it. In fact the example I gave below which is from a
> >> real trace shows it being printed. It is just printed after the error
> >> message rather than before.
> >>
> >> You solution doesn't appear to address the problem of what to do if
> >> they ask for only DDL and one of those generates a syntax error.
> >
> > My comment was that if they type "UP8ATE", and it is a syntax error, we
> > have no way to know if it was a DDL or not, so we don't print it.
> >
> > My idea was to take log_statement, and instead of true/false, have it
> > be all, ddl, mod, or off/none/false(?). You keep the existing test for
> > log_statement where it is, but test for 'all' now, and after parse, you
> > check for ddl or mod, and print in those cases if the tag matches.
> >
> > If they want ddl and errors, they can use log_min_error_statement to
> > see just statement error, and set log_statement accordingly.
> >
>
> The problem is that you are anticipating my solution for the selectivity
> issue before I have written or submitted it. My question was different and
> narrower - namely will the patch I sent, as it stands, and forgetting the
> selectivity issue for the moment, break anything?
>
> When I actually send in a patch to implement statement log selectivity, I
> will give you free license to pull it to bits to your heart's content.

Well, if that is the question, then I don't want to reorder the query
printout from the error.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-03-12 20:23:33 Re: defer statement logging until after parse
Previous Message Bruce Momjian 2004-03-12 20:19:08 Re: Update tests & memory leak fix