Обсуждение: Error help

I'm running PG 7.1 on Solaris.  I recently dropped a table and recreated
it, using identical data.  There are a couple of tables that use a field
in this table as a foreign key.  NOw when I try to get results back from
a view that uses this table, I get the following error:

ERROR:  relation_info: Relation 23949386 not found

and when I try to look at the view using \d, I get

ERROR:  cache lookup of attribute 19 in relation 23949386 failed

Anybody have an idea what these errors mean?  TIA

--
jeremy
http://www.webhack.com

Jeremy Ashcraft <ashcraft@13monkeys.com> writes:
> I'm running PG 7.1 on Solaris.  I recently dropped a table and recreated
> it, using identical data.  There are a couple of tables that use a field
> in this table as a foreign key.  NOw when I try to get results back from
> a view that uses this table,

You need to drop and recreate the view, too.

            regards, tom lane