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