| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| 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:35:24 |
| Message-ID: | 17886.999822924@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nils Zonneveld | 2001-09-07 08:10:32 | Re: Combine query views into one SQL string |
| Previous Message | Stephan Szabo | 2001-09-07 00:23:45 | Re: duplicated oid |