Hi Alexandre, On Tue, Oct 22, 2013 at 10:58 AM, Alexandre Neto <[email protected]>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 <[email protected]>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
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
