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

Aarni Ruuhimäki wrote:

> Hi,
>
> And thanks for the tip Tom.
>
> 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: ""

test=# alter table test alter column b set default '' ;
ERROR:  invalid input syntax for integer: ""




Regards
Gaetano Mendola