Postgres Pro
Downloads
Home   >   mailing lists

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

From Rebecca Clarke
Subject Re: Databas has no Object Identifier Types & Functions
Date
Msg-id CAMChtdcrhGT=mc3xMqXG5d5cEEshXTukdsWdVEZS7_egc=a+SQ@mail.gmail.com
Whole thread Raw
In response to Re: Databas has no Object Identifier Types & Functions  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Responses Re: Databas has no Object Identifier Types & Functions
List pgsql-general
Tree view
Returns 0 rows.


On Tue, Sep 4, 2012 at 11:41 AM, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:


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: Pavan Deolasee
Date:
Subject: Re: Databas has no Object Identifier Types & Functions
Next
From: "himanshu.joshi"
Date:
Subject: Re: Postgres not getting logged in from command prompt