Re: Sequence error ? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Sequence error ?
Date
Msg-id 23013.1085496291@sss.pgh.pa.us
Whole thread Raw
In response to Sequence error ?  (Aarni Ruuhimäki <aarni.ruuhimaki@kymi.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: Sequence error ?
Next
From: Aarni Ruuhimäki
Date:
Subject: Fwd: Re: Sequence error ?