From: | Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Sequence error ? |
Date: | 2004-05-25 12:19:16 |
Message-ID: | 200405251519.16048.aarni.ruuhimaki@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
Trying to import data from a dump into 7.4.1
Here's the dump:
------snip-------
CREATE SEQUENCE "users_id_seq" start 1 increment 1 maxvalue
9223372036854775807 minvalue 1 cache 1;
--
-- TOC Entry ID 28 (OID 37618312)
--
-- Name: users Type: TABLE Owner: postgres
--
CREATE TABLE "users" (
"id" integer DEFAULT nextval('"users_id_seq"'::text) NOT NULL,
"username" character varying(15) NOT NULL,
"password" character varying(15) NOT NULL,
...
"is_newuser" boolean DEFAULT 't' NOT NULL,
Constraint "users_pkey" Primary Key ("id")
------/snip-------
And here's the error:
------snip-------
CREATE SEQUENCE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey"
for table "users"
ERROR: invalid input syntax for integer: ""
------/snip-------
Data for the table:
------snip-------
-- Name: users Type: TABLE DATA Owner: postgres
--
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');
------/snip-------
All other sequences and tables are created just fine with no errors.
Anyone ?
Thanks and best regards,
Aarni
-------------------------------------------------
This is a bugfree broadcast to you from a linux system.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-05-25 14:44:51 | Re: Sequence error ? |
Previous Message | Glenn_Wiens | 2004-05-24 21:24:25 | Re: Problem with encode() function |