Re: Are duplicated OIDs troublesome?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Are duplicated OIDs troublesome?
Дата
Msg-id 14208.1001172706@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Are duplicated OIDs troublesome?  (David Santinoli <u235@libero.it>)
Список pgsql-general
David Santinoli <u235@libero.it> writes:
> going to dump/reload the databases WITH OIDS, and there's a high risk
> that some rows in the first database will have same OIDs as some rows
> from the second one. As long as the clashing rows belong to different
> databases, however, it seems there's no trouble with them. To which
> extent is this correct?

The system won't mind.  There are duplicate OIDs in every database
already --- consider system tables like pg_class, which have the
same OID in every DB, even though they're different tables.

            regards, tom lane

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

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: creating "user" table
Следующее
От: "Gurunandan R. Bhat"
Дата:
Сообщение: Problem while logging primary key of updated field.