RE: RE: OID wraparound (was Re: pg_depend)
От | Henshall, Stuart - WCP |
---|---|
Тема | RE: RE: OID wraparound (was Re: pg_depend) |
Дата | |
Msg-id | E2870D8CE1CCD311BAF50008C71EDE8E01F7463B@MAIL_EXCHANGE обсуждение исходный текст |
Ответ на | OID wraparound (was Re: pg_depend) (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
I was thinking that this would help stop OID wrap around while not totally breaking clients that used OIDs as row identifiers as they'd now have the int4 primary key value (although I guess there could be risks if the client assumes there'd be globally unique). Also the primary key would have to be placed into the OID in all places it could be referenced (for WHERE clauses,etc...). It'd only work on those tables that had int4 priamary keys, but I suspect thats a fair few. I don't know wether this'd be worth while, but was rather throwing it out for thought. - Stuart > -----Original Message----- > From: Hiroshi Inoue [SMTP:Inoue@tpf.co.jp] > Sent: Tuesday, July 24, 2001 2:37 AM > To: Henshall, Stuart - WCP > Cc: 'pgsql-hackers@postgresql.org' > Subject: Re: [HACKERS] RE: OID wraparound (was Re: pg_depend) > > "Henshall, Stuart - WCP" wrote: > > > > Would it be possible to offer an option for the OID column to get its > value > > from an int4 primary key (settable on a per table basis maybe)? > > - Stuart > > > > Sorry I don't understand well what you mean. > What kind of advantages are there if we let OIDs be optional > and allow such options like you offer ? > > regards, > Hiroshi Inoue
В списке pgsql-hackers по дате отправления: