Re: Fwd: Re: Sequence error ? - Mailing list pgsql-novice

Gaetano Mendola <mendola@bigfoot.com> writes:
> Aarni Ruuhim�ki 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