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

more on phantom record

From: Brett McCormick <brett(at)work(dot)chicken(dot)org>
To: pgsql-hackers(at)hub(dot)org
Subject: more on phantom record
Date: 1998-07-15 03:57:55
Message-ID: 13740.10435.278707.768453@web0.speakeasy.org (view raw or flat)
Thread:
Lists: pgsql-hackers
strangeness!

it was the cocurrence of the command which was messing it up.  i ran
the command several times in a row, each one backgrounded.  sure
enough, after a while I got an error "Update: cannot insert duplicate
key into unique index".  I don't believe this error was present
before, it barfs only after the record has been duplicated and *then*
updated, because then the primary key is checked for uniqueness.

thus, the record is un-updatable.
I plan to get rid of it using the following method:

1) select the offending records into temp table
2) delete the offending records from original table
3) copy the temp table to stdout, then copy one of those records back in.
4) drop temp table

very strange.

pgsql-hackers by date

Next:From: Herouth MaozDate: 1998-07-15 10:04:26
Subject: Re: [INTERFACES][HACKERS] atttypmod now 32 bits, interface change
Previous:From: Brett McCormickDate: 1998-07-15 03:49:35
Subject: two records with same oid, freak accident?

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