Re: OID

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: OID
Дата
Msg-id hq5o2vo97kljcuckf9kqq3ja9p2651fm5l@4ax.com
обсуждение исходный текст
Ответ на OID  ("Chris Boget" <chris@wild.net>)
Список pgsql-novice
On Mon, 20 Jan 2003 08:28:22 -0600, "Chris Boget" <chris@wild.net>
wrote:
>Could someone explain what this is

A database wide 32 bit identifier, automatically assigned to each new
tuple, unless you created the table WITHOUT OIDS or (as of 7.3) you
created the table by CREATE TABLE AS ...  (see recent discussion on
-hackers: "default to WITHOUT OIDS").  OID is not guaranteed to be
unique, because it can roll over, and its use as a PK for user tables
is discouraged.

> and what it's used for?

It's heavily used for identifying internal objects.  For user tables
it is only overhead, unless you make explicit use of it.

Servus
 Manfred

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UNION?
Следующее
От: "Chris Boget"
Дата:
Сообщение: Re: OID