Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> Aarni Ruuhimki wrote:
>> There was a slight contradiction in this:
>> "country" integer DEFAULT '' NOT NULL,
> How was possible for you create that table ?
> on 7.4.1 I get:
> test=# create table test ( b integer, a integer default '' not null );
> ERROR: invalid input syntax for integer: ""
Yeah, but before 7.3 pg_atoi would have silently accepted '' as meaning
zero. So the problem wouldn't show up until Aarni updated ...
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Andrew Hammond||Date: 2004-05-25 21:51:17|
|Subject: Re: New from mssql. Help please|
|Previous:||From: Gaetano Mendola||Date: 2004-05-25 17:39:10|
|Subject: Re: Fwd: Re: Sequence error ?|