Re: trouble caused by change in 7.3 handling of '' in

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Vivek Khera <khera(at)kcilink(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: trouble caused by change in 7.3 handling of '' in
Date: 2002-12-18 21:36:14
Message-ID: 173450000.1040247373@lerlaptop.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)kcilink(dot)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(at)kciLink(dot)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(at)postgresql(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keehan Mallon 2002-12-18 21:37:47 Re: Measuring CPU time use? (Another stupid question)
Previous Message Vivek Khera 2002-12-18 21:06:25 trouble caused by change in 7.3 handling of '' in integer context