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

From Larry Rosenman
Subject Re: trouble caused by change in 7.3 handling of '' in
Date
Msg-id 173450000.1040247373@lerlaptop.iadfw.net
Whole thread Raw
In response to trouble caused by change in 7.3 handling of '' in integer context  (Vivek Khera <khera@kcilink.com>)
Responses Re: trouble caused by change in 7.3 handling of '' in  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
That explains why my RT started acting wierd (it's in test).

This also breaks PHPGroupware as well. (I've reported it to them).

Is there any way to get this to be a postgresql.conf option for transition?

LER


--On Wednesday, December 18, 2002 16:06:25 -0500 Vivek Khera
<khera@kcilink.com> wrote:

> I see in the 7.3 HISTORY file this:
>
>      * An empty string ('') is no longer allowed as the input into an
>        integer field. Formerly, it was silently interpreted as 0.
>
> This is causing major issues with the Request Tracker program
> <http://www.bestpractical.com/rt>.
>
> The author has gone so far as to notify all current users that
> Postgres 7.3 is not usable with RT, and to stick to 7.2, or to use
> MySQL.
>
> Apparently, there is a lot of work that will be necessary to retrofit
> RT to this change.  Is there any way possible to make this a logged
> warning rather than a fatal so that there is time to transition the RT
> code?  I didn't see any notice in any prior release of the upcoming
> change.
>
> This unfortunately locks me into the 7.2 line until (if) RT can be
> fixed up, and I could really use the 7.3 improvements for my other
> applications.
>
> Thanks.
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>



--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749




pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: trouble caused by change in 7.3 handling of '' in integer context
Next
From: Keehan Mallon
Date:
Subject: Re: Measuring CPU time use? (Another stupid question)