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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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