dpage@vale-housing.co.uk wrote
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?
You are right. My queries included plpgsql functions and
> 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 u
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