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

Fwd: Re: Sequence error ?

From: Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fwd: Re: Sequence error ?
Date: 2004-05-25 15:57:47
Message-ID: 200405251857.47084.aarni.ruuhimaki@kymi.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)sss(dot)pgh(dot)pa(dot)us>
To: aarni(dot)ruuhimaki(at)kymi(dot)com
Cc: pgsql-novice(at)postgresql(dot)org

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

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

Responses

pgsql-novice by date

Next:From: Gaetano MendolaDate: 2004-05-25 17:39:10
Subject: Re: Fwd: Re: Sequence error ?
Previous:From: Tom LaneDate: 2004-05-25 14:44:51
Subject: Re: Sequence error ?

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