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
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? |