Re: [pgadmin-support] Deleting an index confuses SQL dialogue window

2006-10-29 Thread Erwin Brandstetter
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

Re: [pgadmin-support] Deleting an index confuses SQL dialogue window

2006-10-28 Thread Dave Page
> 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

[pgadmin-support] Deleting an index confuses SQL dialogue window

2006-10-27 Thread Erwin Brandstetter
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