trouble caused by change in 7.3 handling of '' in integer context

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: trouble caused by change in 7.3 handling of '' in integer context
Date: 2002-12-18 21:06:25
Message-ID: x7n0n3doku.fsf@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2002-12-18 21:36:14 Re: trouble caused by change in 7.3 handling of '' in
Previous Message Joe Conway 2002-12-18 21:03:05 Re: Measuring CPU time use? (Another stupid question)