Re: Deleting an index confuses SQL dialogue window

#1 (**permalink**) 04-17-2008, 08:37 PM

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode