alter table A: relation <unknown table not A > error

From: "Miguel Carvalho" <miguel(at)ipatimup(dot)pt>
To: <pgsql-general(at)postgresql(dot)org>
Subject: alter table A: relation <unknown table not A > error
Date: 2002-10-22 09:09:56
Message-ID: 1533.213.13.176.13.1035277796.squirrel@www.ipatimup.up.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi every one,

i'm having a trouble with an alteration( add a column ) to a table.

When i issue a update table A add ... the result is

ERROR: relation <strange table> not found.

Right now i'm running PostgreSQL 7.2.1, but the database has been migrated
from PostgreSQL 7.1 via an SQL dump.
The mysterious table has existed on my database( on pg 7.1 ) as a
temporary table...after that i have just dopped the table.
I have searched every references on pg_class and pg_triggers to this
mysterious table, but i haven't found anything.
Is there any way of vaerifying the logical integrity of the catalog
tables( pg_* )?
Does any one have a clue for this?

Thank's
Miguel Carvalho

Browse pgsql-general by date

  From Date Subject
Next Message darthxiong 2002-10-22 09:49:12 big pg_attribute_relid_attnam_index files
Previous Message Tommi Maekitalo 2002-10-22 06:50:58 Re: : Errors when compiling with Postgres 7.2.3 Libraries on RedHat 8