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

[Alexandre Neto]

Yes, I believe it is. At least the fact that only closing QGIS releases the
locks.
You can even create several locks on the same table if you keep removing
and adding the same table.

But, is it expected that a QGIS client can lock a postgis view in such way
that I can not even run a trigger on a related table? When I tried, QGIS
just hangs until I close the process in Postgresql. The opposite happens
when I try to delete a View via Pgadmin that is opened in QGIS, pgadmin
hangs until I close QGIS.

Thanks,

Alexandre




On Mon, Oct 21, 2013 at 8:56 PM, Nyall Dawson <nyall.dawson at gmail.com>wrote:

>
> 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].
>>
>>
>>
> There's already a report with some details regarding this:
> http://hub.qgis.org/issues/7679
>
> I think it's related.
>
> Cheers,
> Nyall
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131022/8a455b3f/attachment.html>