Re: OID wraparound (was Re: pg_depend)
От | Larry Rosenman |
---|---|
Тема | Re: OID wraparound (was Re: pg_depend) |
Дата | |
Msg-id | 20010718.21355900@ler-freebie.iadfw.net обсуждение исходный текст |
Ответ на | Re: OID wraparound (was Re: pg_depend) (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: OID wraparound (was Re: pg_depend)
|
Список | pgsql-hackers |
Didn't know about that one, at least from the reading of the docs... Thanks, You answered the question. I knew OID's weren't unique, but they are likely to be able to distinguish between 2 rows in the same table. Maybe ctid needs to be documented better? LER >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 7/18/01, 4:32:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote regarding Re: OID wraparound (was Re: [HACKERS] pg_depend) : > Bruce Momjian <pgman@candle.pha.pa.us> writes: > >> Also, without OID's, how do you fix EXACT duplicate records that happen > >> by accident? > > How about tid's? SELECT tid FROM tab1. > "SELECT ctid", actually, but that is still the fallback. (Actually > it always was --- OIDs aren't necessarily unique either, Larry.) > regards, tom lane
В списке pgsql-hackers по дате отправления: