Re: OID Usage

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: OID Usage
Дата
Msg-id 20050114232438.GB29663@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: OID Usage  (Bo Lorentsen <bl@netgroup.dk>)
Ответы Re: OID Usage  (Bo Lorentsen <bl@netgroup.dk>)
Список pgsql-general
On Sat, Jan 15, 2005 at 12:06:41AM +0100, Bo Lorentsen wrote:

> Ok, Tom told me about the same :-(  But why are oid's still in PG, that
> are they good for ? Will there be a real unique row id, like there is in
> Oracle, or will this be keept as an internal value only ?

Most system catalogs use OIDs as primary keys.  So they cannot just
disappear.  But on user tables, there's not a lot of use for them IMHO.

There's no internal row id on Postgres; having one would mean more
storage requirements.  If you want one, you know where to get it ... if
not, you may as well save the space.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"No hay cielo posible sin hundir nuestras raíces
 en la profundidad de la tierra"                        (Malucha Pinto)

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: OID Usage
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [HACKERS] Much Ado About COUNT(*)