serial sequence problem with existing keys

From: Randall Perry <rgp(at)systame(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: serial sequence problem with existing keys
Date: 2001-10-31 15:59:29
Message-ID: B8058A11.1323E%rgp@systame.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've had to modify a parent table by recreating it (I substituted integer
foreign key values from lookup tables for text in 2 fields. As postgres
doesn't have a DROP COLUMN command I couldn't revise the table structure
without rebuilding it) .

It has a serial data type for the primary key. I'm importing the data back
in and need to keep the original primary key values, as they're used in
several child tables.

But, if I put in my own key values in a serial field the auto-increment
sequence uses the next number from where it left off, and not the max value,
and complains that it can't create a duplicate key.

Is there any way around this, or am I going to have to programmatically
increment the key and change serial to int?

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 561.589.6449
mobile email help(at)systame(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-10-31 16:27:10 Re: alter table workaround
Previous Message Raise Exception 2001-10-31 15:52:14 Best way to store/search phone numbers?