Обсуждение: Fwd: Re: Sequence error ?

Hi,

And thanks for the tip Tom.

There was a slight contradiction in this:

"country" integer DEFAULT '' NOT NULL,

Best regards,

Aarni

----------  Forwarded Message  ----------

Subject: Re: [NOVICE] Sequence error ?
Date: Tue, 25 May 2004 10:44:51 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: aarni.ruuhimaki@kymi.com
Cc: pgsql-novice@postgresql.org

Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni.ruuhimaki@kymi.com> writes:
> ERROR:  invalid input syntax for integer: ""
> [from]
> INSERT INTO "users" VALUES (1,'xxxxxxxx','yyyyyyyy',0,'9999-12-12
> 00:00:00','2004-03-03
> 15:49:28.028026+02','xxxxxxxx','xxxxxxxxr','','','','','','','t',0,'t');

You didn't show us all the column definitions, but are any of the ninth
through fourteenth columns integers?  That's certainly where I'd look on
the basis of this error ...

            regards, tom lane

-------------------------------------------------------
This is a bugfree broadcast to you from a linux system.

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

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