Returns 0 rows.
On Tue, Sep 4, 2012 at 11:41 AM, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>wrote:
>
>
> On Tue, Sep 4, 2012 at 3:58 PM, Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>wrote:
>
>> Hi there,
>>
>> I'm running postgresql 8.4 on a debian system. I have a database that has
>> no object identifier types and functions in the pg_catalog,
>> e.g. regclass, regclassout.
>>
>>
> Are you sure you don't have them ? I thought regclass is quite old, but I
> may be wrong. What does the following query returns ?
>
> SELECT * FROM pg_type WHERE typname = 'regclass';
>
> Thanks,
> Pavan
>