Re: reindexdb program error under PG 8.1.3

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: David Wall <d(dot)wall(at)computer(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: reindexdb program error under PG 8.1.3
Date: 2006-05-25 21:49:16
Message-ID: 20060525214916.GA9179@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David,

On Thu, May 25, 2006 at 02:07:27PM -0700, David Wall wrote:
> >object. Look in template1 and see if you see a table with that OID.

> Thanks, but I clearly lack that expertise. How do I find "a table with
> that OID"?

Do a normal select against pg_class. Something like:

select oid, relname from pg_class

Joachim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2006-05-25 22:27:13 Re: What to expect when mixing inherited tables and different schemas while dealing with functions and views?
Previous Message David Wall 2006-05-25 21:07:27 Re: reindexdb program error under PG 8.1.3