DROP VIEW lasts forever - Mailing list pgsql-general

From Christian Rengstl
Subject DROP VIEW lasts forever
Date
Msg-id 47160803.90AD.0080.0@klinik.uni-regensburg.de
Whole thread Raw
Responses Re: DROP VIEW lasts forever  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
Re: DROP VIEW lasts forever  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
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 psql 8.2

Thanks in advance



Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230




pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: insert continue on error
Next
From: "Christian Rengstl"
Date:
Subject: Re: DROP VIEW lasts forever