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

[Giuseppe Sucameli]

Hi Alexandre,

On Tue, Oct 22, 2013 at 10:58 AM, Alexandre Neto <senhor.neto at gmail.com>wrote:

> Yes, I believe it is. At least the fact that only closing QGIS releases
> the locks.
>

I've pushed a fix for this issue.
Please, confirm if it works now.

Cheers.
Giuseppe


> 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
>>
>>
>
>


-- 
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20131025/dce14816/attachment.html>