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