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
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 |