[Qgis-user] Opening view or table using DBManager locks it in postgis

[Giuseppe Sucameli]

Hi Alexandre,

On Mon, Oct 21, 2013 at 5:51 PM, Alexandre Neto <senhor.neto at gmail.com>
wrote:
>
> Opening with DBManager creates lots of locks in postgres (see below),
that are only released when QGIS is closed. During the lock, it seems
impossible to alter specific tables or views.
>
> (...)
>
> Is this expected?

no, that's not the intended behaviour.

Shared locks for select queries are ok (that's how postgres works) but they
must be released once cursors are closed (or even deleted).

Please, file a ticket on the QGIS trac [1].

Regards.

[1] http://hub.qgis.org/projects/quantum-gis/issues

--
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131021/1043f6ad/attachment.html>