Re: Feature request - CREATE TYPE ... WITH OID = oid_number.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Feature request - CREATE TYPE ... WITH OID = oid_number.
Дата
Msg-id 24583.1291743428@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Feature request - CREATE TYPE ... WITH OID = oid_number.  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Feature request - CREATE TYPE ... WITH OID = oid_number.  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Feature request - CREATE TYPE ... WITH OID = oid_number.  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> On Tue, Dec 7, 2010 at 11:49 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Say what? �He didn't say that, he said "don't assume that user-defined
>> types have hard-wired OIDs".

> Well, you're right, strictly speaking.  Of course, the OP is not
> assuming it, he is enforcing it.

No, he's wishing he could enforce it.  Which will work, mostly, until
the day it doesn't because of a pre-existing collision.  And then he'll
be up the creek with a lot of software that he can't fix readily.  I
concur with Andrew's advice: don't go there in the first place.  Use a
cache to mitigate the costs of looking up user-defined OIDs, and you
won't regret it later.
        regards, tom lane


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Feature request - CREATE TYPE ... WITH OID = oid_number.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: pg_execute_from_file review