DROP VIEW lasts forever

From: "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: DROP VIEW lasts forever
Date: 2007-10-17 11:01:25
Message-ID: 47160803.90AD.0080.0@klinik.uni-regensburg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Rengstl 2007-10-17 11:10:12 Re: DROP VIEW lasts forever
Previous Message postgresql.*.thewild 2007-10-17 10:54:43 dblink and hostname resolution problem