Re: Databas has no Object Identifier Types & Functions

[Pavan Deolasee <pavan.deolasee@xxxxxxxxx>]

On Tue, Sep 4, 2012 at 3:58 PM, Rebecca Clarke <r.clarke83@xxxxxxxxx> 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