general question on OIDs

Поиск
Список
Период
Сортировка
От Oliver Vecernik
Тема general question on OIDs
Дата
Msg-id 3AF436A6.8BFAC3FD@aon.at
обсуждение исходный текст
Ответы Re: general question on OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi,

Using of OIDs as foreign keys is recommended in the docs. It is a unique
number for every object of the PostgreSQL server. I can dump OIDs with
-o option.

But what happens if I have to upgrade my server? For example for the new
7.1 release an initdb is required. OIDs start from 16384 or something.
After importing my old databases can I expect that OIDs are not unique
any more? Or is there any other handling to prevent this?

Regards,
Oliver

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

Предыдущее
От: Michael Davis
Дата:
Сообщение: RE: URGENT HELP NEEDED
Следующее
От: Tom Lane
Дата:
Сообщение: Re: general question on OIDs