Skip site navigation (1) Skip section navigation (2)

Re: Sequence error ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aarni(dot)ruuhimaki(at)kymi(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Sequence error ?
Date: 2004-05-25 14:44:51
Message-ID: 23013.1085496291@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni(dot)ruuhimaki(at)kymi(dot)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

In response to

pgsql-novice by date

Next:From: Aarni RuuhimäkiDate: 2004-05-25 15:57:47
Subject: Fwd: Re: Sequence error ?
Previous:From: Aarni RuuhimäkiDate: 2004-05-25 12:19:16
Subject: Sequence error ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group