pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedduplicated oid
4+ messages / 3 participants
[nested] [flat]
* duplicated oid
@ 2001-09-03 04:41 Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-09-06 23:53 ` Re: duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
0 siblings, 1 reply; 4+ messages in thread
From: Carolyn Lu Wong @ 2001-09-03 04:41 UTC (permalink / raw)
To: pgsql-sql
i'm using V6.5.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: duplicated oid
2001-09-03 04:41 duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
@ 2001-09-06 23:53 ` Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-09-07 00:23 ` Re: duplicated oid Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-09-07 00:35 ` Re: duplicated oid Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: Carolyn Lu Wong @ 2001-09-06 23:53 UTC (permalink / raw)
To: pgsql-sql
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?
Carolyn Lu Wong wrote:
>
> i'm using V6.5.
>
> >From my understanding, the oid should be unique in all rows of database.
> However, I'm getting duplicated data on one particular table, including
> the oid is the same! I don't recall trying to restore nor import any
> data.
>
> Any idea why?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: duplicated oid
2001-09-03 04:41 duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-09-06 23:53 ` Re: duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
@ 2001-09-07 00:23 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
1 sibling, 0 replies; 4+ messages in thread
From: Stephan Szabo @ 2001-09-07 00:23 UTC (permalink / raw)
To: Carolyn Lu Wong <carolyn@greatpacific.com.au>; +Cc: 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 :) )
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: duplicated oid
2001-09-03 04:41 duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-09-06 23:53 ` Re: duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
@ 2001-09-07 00:35 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2001-09-07 00:35 UTC (permalink / raw)
To: Carolyn Lu Wong <carolyn@greatpacific.com.au>; +Cc: pgsql-sql
Carolyn Lu Wong <carolyn@greatpacific.com.au> writes:
> anyone knows if duplicated oid is possible??
Yes, if you don't have a unique index on it and you've generated more
than four billion rows in the database.
> is there a possible way to remove the duplicate row, now that i don't
> know which ID to use? any suggestions?
Use ctid to distinguish the rows. Note ctid will change if you update
a row, so it's not a permanent identifier either, but it will serve for
deleting a row.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-09-07 00:35 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-03 04:41 duplicated oid Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-09-06 23:53 ` Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-09-07 00:23 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-09-07 00:35 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox