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

Sequence error ?

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

Trying to import data from a dump into 7.4.1

Here's the dump:

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")

And here's the error:

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" 
for table "users"
ERROR:  invalid input syntax for integer: ""

Data for the table:

-- Name: users Type: TABLE DATA Owner: postgres

INSERT INTO "users" VALUES (1,'xxxxxxxx','yyyyyyyy',0,'9999-12-12 

All other sequences and tables are created just fine with no errors.

Anyone ?

Thanks and best regards,


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


pgsql-novice by date

Next:From: Tom LaneDate: 2004-05-25 14:44:51
Subject: Re: Sequence error ?
Previous:From: Glenn_WiensDate: 2004-05-24 21:24:25
Subject: Re: Problem with encode() function

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