Sequence error ?

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.