Re: pg7.3.4: pg_atoi: zero-length string

From: Rob Fielding <rob(at)dsvr(dot)net>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg7.3.4: pg_atoi: zero-length string
Date: 2003-11-04 12:19:58
Message-ID: 3FA7996E.9020705@dsvr.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Sullivan wrote:
> On Tue, Nov 04, 2003 at 11:21:35AM +0000, Rob Fielding wrote:
>
>>
>>Hi,
>>
>>We're currently experiencing a problem where SQL statements are failing
>>when entring a '' for not not-null integer columns:
>
>
> Yes. This behaviour was made more compliant in 7.3. It's in the
> release notes.
>
>
>>The above example in just one case where 'aid' can accept a null value.

I've found this is a feature of 7.3 to not treat a empty string as a
NULL integer type. Silly lazy me ;)

As it turned out it relatively trivial to fix the offending statements
on the few occasions where it has been valid to do this.

Consider this a non-issue.

Cheers,

--

Rob Fielding
Development
Designer Servers Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francois Suter 2003-11-04 12:31:08 Re: Very strange selectproblem
Previous Message Victor Spång Arthursson 2003-11-04 12:10:16 Very strange selectproblem