Re: pg_class and enum types

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: pg_class and enum types
Дата
Msg-id 4A19BB0E.2000001@dunslane.net
обсуждение исходный текст
Ответ на Re: pg_class and enum types  (Gevik Babakhani <pgdev@xs4all.nl>)
Ответы Re: pg_class and enum types  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Gevik Babakhani wrote:
> Robert Haas wrote:
>> On Sun, May 24, 2009 at 4:37 PM, Gevik Babakhani <pgdev@xs4all.nl> 
>> wrote:
>>  
>>> I was wondering why there is no pg_class record for the enum types. 
>>> Do we
>>> treat the enum types differently?
>>>     
>>
>> Because types are stored in pg_type, not pg_class?
>>
>> ...Robert
>>   
> That is certainly not true.... check the following...
>
> create type test_type as
> (
> field1 integer,
> field2 varchar
> );
>
> select * from pg_class where relname='test_type'

It's not so much that enum types are handled specially, but that 
composite types are. :-)

There is no pg_class entry for int either.

cheers

andrew


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: pg_class and enum types
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pull raw text of a message by message-id