Re: pg_class and enum types

Поиск
Список
Период
Сортировка
Искать
От
Andrew Dunstan
Тема
Re: pg_class and enum types
Дата
в 18:24:37
Msg-id
4A19BB0E.2000001@dunslane.net
Ответ на
Re: pg_class and enum types (Gevik Babakhani)
Список
Дерево обсуждения
pg_class and enum types Gevik Babakhani <pgdev@xs4all.nl>
Re: pg_class and enum types Andrew Dunstan <andrew@dunslane.net>
Re: pg_class and enum types Gevik Babakhani <pgdev@xs4all.nl>
Re: pg_class and enum types Robert Haas <robertmhaas@gmail.com>
Re: pg_class and enum types Gevik Babakhani <pgdev@xs4all.nl>
Re: pg_class and enum types Andrew Dunstan <andrew@dunslane.net>
Re: pg_class and enum types Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_class and enum types Gevik Babakhani <pgdev@xs4all.nl>


Gevik Babakhani wrote:
> Robert Haas wrote:
>> On Sun, May 24, 2009 at 4:37 PM, Gevik Babakhani  
>> 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
Дата:
FAQ