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

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: trouble caused by change in 7.3 handling of '' in
Date: 2002-12-19 17:06:08
Message-ID: 2600000.1040317568@lerlaptop.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--On Thursday, December 19, 2002 12:01:21 -0500 Bruce Momjian
<pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:

> Vivek Khera wrote:
>> >>>>> "PE" == Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>>
>> PE> It's one thing to have warts for allowing the market-leading GUI
>> frontend PE> for databases (MS Access) to work, but if every, with all
>> due respect, PE> random client wants to have its own
>> break-the-spec-for-me switch we'll go PE> mad.
>>
>> PE> Explain to me why it's so hard to say 0 when you mean 0.
>>
>> It is not hard. What is hard is when you change behavior abruptly
>> between releases without a transition period in which you warn about
>> an upcoming change when that deprecated feature is used. Ideally, it
>> would have logged this error for the 7.3 release, and disallowed it
>> for 7.4, something akin to the LIMIT transition.
>>
>> I guess nobody realized how some popular applications used this
>> non-compliant feature before the change was implemented. Perhaps we
>> learn from this experience and don't do this type of change again.
>> Perhaps not.
>
> Yes, this was really it --- we didn't realize how many apps used this.
> Also, we expected to hit them before final release, when we could have
> reverted the change.
IT DID! (see my post during Beta).

You said, well, that's only one.

>
> The prompting of the change was that '' -> 0 didn't make sense, and
> it was masking some COPY file format errors.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
> 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
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 javier garcia 2002-12-19 17:11:29 Database superuser
Previous Message Bruce Momjian 2002-12-19 17:01:21 Re: trouble caused by change in 7.3 handling of '' in