Cannot insert a duplicate key into unique index

#11

hi kj,

select nextval('shipments_ship_id_seq');
then add one to that, say it's now equal 1010 ...
SELECT setval('shipments_ship_id_seq', 1010);

source =

http://www.commandprompt.com/ppbook/...EQUENCEVAL UE

but, sometimes there are deeper problems, as you alluded to.

On Thu, Feb 19, 2004 at 03:18:45PM +1100, Noel wrote:

Quote:

Hi KJ,

For each SERIAL primary key, there is a sequence table for that table,
which is where the primary key is generated. You need to check to see
that the current counter in the sequence table is passed the MAX primary
key in your table.
eg:
TABLE A
id (pkey)

Will have a sequence table
A_id_seq

Hope that helps
Cheers
Noel

kynn (AT) panix (DOT) com wrote:

I'm trying to debug some problem in my database that is resulting in
an error of the form "Cannot insert a duplicate key into unique
index". The insert statement that is producing this error does not
include a value for the pkey field in question (this field is of type
SERIAL). I imagine that somehow the counter associated with this
field got messed up, so that it is mistakenly generating a value that
has been used already. How can I straighten it out?

Thanks!

kj
--

joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cannot insert a duplicate key into unique index

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: Cannot insert a duplicate key into unique index - 06-03-2004 , 10:40 PM