Re: duplicated oid - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: duplicated oid
Date
Msg-id Pine.BSF.4.21.0109061718180.95546-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: duplicated oid  (Carolyn Lu Wong <carolyn@greatpacific.com.au>)
List pgsql-sql
On Fri, 7 Sep 2001, Carolyn Lu Wong wrote:

> anyone knows if duplicated oid is possible?? 
> 
> is there a possible way to remove the duplicate row, now that i don't
> know which ID to use? any suggestions?

Hmm, that's wierd.
AFAIK that should only occur in cases like copy with oids and oid wrap
around (but that'd be unlikely to give you the same row twice).  I'd
guess copy with oids or a plain bug would be more likely.

You can probably use ctid to differentiate between the rows for a delete.

(And you should probably look at upgrading :) )



pgsql-sql by date:

Previous
From: Carolyn Lu Wong
Date:
Subject: Re: duplicated oid
Next
From: Tom Lane
Date:
Subject: Re: duplicated oid