Error help

Поиск
Список
Период
Сортировка
Искать

Error help

От:
Jeremy Ashcraft <ashcraft@13monkeys.com>
Дата:
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

Re: Error help

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jeremy Ashcraft  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
FAQ