Re: [GENERAL] psql problem describing tables - Mailing list pgsql-general

From Sarah Officer
Subject Re: [GENERAL] psql problem describing tables
Date
Msg-id 3885FCF8.3E69D971@aries.tucson.saic.com
Whole thread Raw
In response to psql problem describing tables  (Sarah Officer <officers@aries.tucson.saic.com>)
List pgsql-general
Let me clarify.  The reason there is not data in my table is because
I haven't inserted any yet.  I inserted a row of data.  It gets
selected correctly, but I still can't describe the table.  So the
problem doesn't seem to be related to having an empty table.

Sarah

Sarah Officer wrote:
>
> I am running postgres 6.5.3 on an SGI.  I haven't done much except
> create a few tables and indexes.  When I enter psql and type '\d',
> all my tables and indexes are listed.  When I type '\d tablename'
> however, I get the following message:
>
> \d Images
> ERROR:  typeidTypeRelid: Invalid type - oid = 0
>
> I can select from the table, but there's no data in it.  I have the
> same problem with all my tables, and I can't describe indexes
> either.  Any suggestions?
>
> Thanks,
>
> Sarah Officer
> officers@aries.tucson.saic.com
>
> ************

pgsql-general by date:

Previous
From: Sarah Officer
Date:
Subject: psql problem describing tables
Next
From: Sarah Officer
Date:
Subject: Trigger problem