| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Vivek Khera <khera(at)kcilink(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: trouble caused by change in 7.3 handling of '' in |
| Date: | 2002-12-19 15:12:07 |
| Message-ID: | 1040310727.24432.30.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2002-12-19 at 10:03, Vivek Khera wrote:
> >>>>> "BM" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2002-12-19 15:12:54 | Re: trouble caused by change in 7.3 handling of '' in |
| Previous Message | Karl DeBisschop | 2002-12-19 15:09:46 | Getting 2002-12-18T17:32:40-05:00 (ISO 8601) from to_date() |