Re: pg_class and enum types - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_class and enum types
Date
Msg-id 4A19BB0E.2000001@dunslane.net
Whole thread Raw
In response to Re: pg_class and enum types  (Gevik Babakhani <pgdev@xs4all.nl>)
Responses Re: pg_class and enum types  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pg_class and enum types
Next
From: Alvaro Herrera
Date:
Subject: Re: pull raw text of a message by message-id