I had a view set up and then went and had to change one of the tables that
was referenced in the view. I needed to drop one of the field in this particular
table so I created a temp table (without the field I wanted to eliminate) and
then moved the data in. I dropped the original table and thought I was ok.
Today I am getting the following error from any query that tries to access
the view.
ERROR: Relation "al_spots" with OID 1132243 no longer exists
I assume that this is because the OIDs were changed when I recreated the
table?
So I decided to recreate the view using the new table but when I try to do
that I get the following error:
ERROR: Attempt to insert rule "_RETam_spots_usf_view" failed: already
exists
I cannot seem to determine what this last error is telling me. Any
thoughts?
Thanks
Jodi Kanter
_______________________________ |
- Re: [ADMIN] broken view? Jodi Kanter
- Re: [ADMIN] broken view? Jodi Kanter