Re: [GENERAL] psql problem describing tables

From: Sarah Officer <officers(at)aries(dot)tucson(dot)saic(dot)com>
To: Sarah Officer <SARAH(dot)M(dot)OFFICER(at)saic(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] psql problem describing tables
Date: 2000-01-19 18:05:44
Message-ID: 3885FCF8.3E69D971@aries.tucson.saic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)aries(dot)tucson(dot)saic(dot)com
>
> ************

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sarah Officer 2000-01-19 18:27:53 Trigger problem
Previous Message Sarah Officer 2000-01-19 17:43:27 psql problem describing tables