[Qgis-developer] [Qgis-user] Opening view or table using DBManager locks it in postgis
Giuseppe Sucameli
brush.tyler at gmail.com
Mon Oct 21 10:42:02 PDT 2013
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-developer/attachments/20131021/1043f6ad/attachment.html>
More information about the Qgis-developer
mailing list