Help with Views and OID

[stressball]

Hi,
I'm new to using posgres, I've mainly used Oracle in the past. I have a system I am designing where I have a View that joins two tables, as I am inserting into 1 table and updating another. I have written a rule to handle the insert and the update. My problem being that I have deleted and dropped my tables several times as the structure and data is changing a little as I develop, and now I get an error message:
ERROR: Relation &quot;<column name>&quot; with OID 39371 no longer exists
I know that, but I deleted the OID, from what I have read Postgres does a table join on the oid not the column key:
I am joining like: Where t.id = k.id, but it seems to be joining on the OID. I want the join on the column value not the OID. Please help, it would be most appreciated

 

[RahulGade]

Solution 1 : Try using another database.

Solution 2 : It seems to be a bug in postgreSQL, You can report to the postgres bug report page or mail the bug details at
pgsql-bugs@postgresql.org , The response from them is very quick, as per my experiance withing 20 hours.



Rahul Gade

If you think you can't do it,You will never be able to do it.

 

[stressball]

Thanks, but what I ended up doing, as I didn't want to have to use another database, is simply drop the view, and recreate it with another name, change the applicable application code, and everything works fine.