From: | Andrew Perrin <aperrin(at)socrates(dot)berkeley(dot)edu> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | all views in database broken at once |
Date: | 2001-03-24 16:16:16 |
Message-ID: | Pine.LNX.4.21.0103241113240.26693-100000@nujoma.perrins |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Greetings-
I'm in a bit of a pickle. I rebuilt a big query on top of which lots of
little queries rest, so as to use some new columns in the query. Now, I
get error messages when trying to access any view that SELECTs from the
rebuilt query:
fgdata=# \d sx_l_m_r_a
ERROR: cache lookup of attribute 197 in relation 47074 failed
fgdata=# select * from pg_views;
ERROR: cache lookup of attribute 317 in relation 48494 failed
A SELECT from the rebuilt query itself works fine, so I know it's not
actually a data problem. Is there anything I can do to rebuild these
views? I don't think I have the original SQL sitting around to drop and
recreate them.
Thanks for any advice.
----------------------------------------------------------------------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Carolina, Chapel Hill)
andrew_perrin(at)unc(dot)edu - http://www.unc.edu/~aperrin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-24 16:39:43 | Re: how do I check if a temporary table exists? |
Previous Message | Peter Eisentraut | 2001-03-24 14:29:49 | Re: Serials. |