Re: broken view?

got it working....I was trying to create and rename the view but apparently that breaks some sort of link.
It worked when I completely removed the existing view and then recreated with original name from scratch.
thanks anyway...
Jodi
----- Original Message -----
From: Jodi Kanter
To: Postgres Admin List
Sent: Monday, March 25, 2002 2:47 PM
Subject: [ADMIN] broken view?

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
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu