Postgres Pro
Downloads
Home   >   mailing lists

Re: Databas has no Object Identifier Types & Functions - Mailing list pgsql-general

From Pavan Deolasee
Subject Re: Databas has no Object Identifier Types & Functions
Date
Msg-id CABOikdMXvZtNNOk3ehrn7YhC4vKocuEZok+V8ESVUJQ3Pb7y8w@mail.gmail.com
Whole thread Raw
In response to Databas has no Object Identifier Types & Functions  (Rebecca Clarke <r.clarke83@gmail.com>)
Responses Re: Databas has no Object Identifier Types & Functions
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: Rebecca Clarke
Date:
Subject: Databas has no Object Identifier Types & Functions
Next
From: Rebecca Clarke
Date:
Subject: Re: Databas has no Object Identifier Types & Functions