Re: [GENERAL] DROP VIEW lasts forever

2007-10-17 Thread Chris Browne
[EMAIL PROTECTED] ("Christian Rengstl") writes: > Whenever I try dropping a view using DROP VIEW myschema.myview the > query runs forever. The last time I tried was ten minutes ago and the > query is still running even though the view queries just data of one > single table with around 5 fields. >

Re: [GENERAL] DROP VIEW lasts forever

2007-10-17 Thread A. Kretschmer
am Wed, dem 17.10.2007, um 13:01:25 +0200 mailte Christian Rengstl folgendes: > Hi list, > > Whenever I try dropping a view using DROP VIEW myschema.myview the > query runs forever. The last time I tried was ten minutes ago and the > query is still running even though the view queries just data o

Re: [GENERAL] DROP VIEW lasts forever

2007-10-17 Thread Christian Rengstl
Nevermind, by mistake I tried dropping it as a different user. But, just a question, wouldn't it make more sense to issue an error message or something instead of letting the query run indefinitely? Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Univer

[GENERAL] DROP VIEW lasts forever

2007-10-17 Thread Christian Rengstl
Hi list, Whenever I try dropping a view using DROP VIEW myschema.myview the query runs forever. The last time I tried was ten minutes ago and the query is still running even though the view queries just data of one single table with around 5 fields. What could be the reason? By the way, I'm using