> 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
