Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP VIEW lasts forever - Mailing list pgsql-general

From A. Kretschmer
Subject Re: DROP VIEW lasts forever
Date
Msg-id 20071017113024.GE31284@a-kretschmer.de
Whole thread Raw
In response to DROP VIEW lasts forever  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
List pgsql-general
Tree view 
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 of one
> single table with around 5 fields.
> What could be the reason?

maybe a look because an other transaction?


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Christian Rengstl"
Date:
Subject: Re: DROP VIEW lasts forever
Next
From: "Sergey Konoplev"
Date:
Subject: Re: pg_cancel_backend() does not work with buzz queries