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 <[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 > >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
