Re: trouble caused by change in 7.3 handling of '' in - Mailing list pgsql-general

From Robert Treat
Subject Re: trouble caused by change in 7.3 handling of '' in
Date
Msg-id 1040310727.24432.30.camel@camel
Whole thread Raw
In response to Re: trouble caused by change in 7.3 handling of '' in integer  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
On Thu, 2002-12-19 at 10:03, Vivek Khera wrote:
> >>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> BM> How about if I give you a patch against 7.3 that allows '' as 0, and you
> BM> ask if the author can distribute it and get his code changed for 7.4?
>
> That would be great.  Actually what would be best is if the code could
> log a warning (with the full query) every time it happened, then it
> would be easy to run the app for a while and find all the places it
> happens.  RT dynamically creates its queries so this would be the
> easiest way to fix it up.  Then RT could be fixed up and not need any
> patches to PG.
>

IIRC 7.3 has this functionality, i think the parameter is
log_min_error_statement in the postgresql.conf

Robert Treat



pgsql-general by date:

Previous
From: Karl DeBisschop
Date:
Subject: Getting 2002-12-18T17:32:40-05:00 (ISO 8601) from to_date()
Next
From: Vivek Khera
Date:
Subject: Re: trouble caused by change in 7.3 handling of '' in