| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: duplicated oid |
| Date: | 2001-09-07 00:23:45 |
| Message-ID: | Pine.BSF.4.21.0109061718180.95546-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 :) )
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-09-07 00:35:24 | Re: duplicated oid |
| Previous Message | Carolyn Lu Wong | 2001-09-06 23:53:37 | Re: duplicated oid |