Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does
Дата
Msg-id 10905.1149866303@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Ответы Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Список pgsql-general
Дерево обсуждения 
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> This is not a large object. We are seeing rows with duplicate oids
> because the OID counter is not changed after the dump (exported with
> --oids) is being loaded.
> How does 8.1 prevent to allocate duplicate OIDs?

If there's a unique index on the OID column then 8.1 will not allocate
duplicate OIDs.  If there's not such a unique index, you had no
guarantee of no-duplicates before 8.1 either.

            regards, tom lane

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

Предыдущее
От: Adam Witney
Дата:
Сообщение: Re: not valid character for Unicode
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model