Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Deleting an index confuses SQL dialogue window

Deleting an index confuses SQL dialogue window



Hi Dave,
the last thing I want is to mess with your blood pressure, but I just might have another one here ...

If I run a query in the SQL dialogue window which utilizes an index and delete this index afterwards, the same query will result in an error after that.

FEHLER: could not open relation with OID 1134569
SQL state: XX000
Context: SQL-Anweisung »SELECT  (...)

Recreating the index under the same name does not help, as pgAdmin seems to be looking for the OID of the index. It seems the query plan is being saved and executed over and over again. Executing other queries in the same SQL dialogue window works fine. Trying the original query keeps failing.
Executing the same query in a new SQL dialogue window works fine.

Not sure if this is a bug or by design. It certainly looks like a bug to me.


Regards
Erwin



Home | Main Index | Thread Index

top