Re: Deleting an index confuses SQL dialogue window

[Dave Page <dpage(at)vale-housing(dot)co(dot)uk>]

> 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.

That error is coming from PostgreSQL - the query tool never looks at any
indexes; it just sends the query and displays whatever comes back. What is
the exact sequence of events needed to reproduce this?

Regards, Dave.