[Qgis-developer] working with qgis and pgadmin/psql...

[Bernhard Ströbl]

Am 10.04.2014 07:58, schrieb Paolo Cavallini:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Il 09/04/2014 20:45, Giovanni Manghi ha scritto:
>
>>> What versions are affected - dev / 2.2 / both?
>>
>>
>> I think both, for sure on master.
>
> It's a long standing problem, present since I can remember.

Me, too. This problem is present as far as I use QGIS together with 
PostGIS (QGIS 1.5 maybe). As far as I can remember only DDL statements 
(e.g. ALTER TABLE) are affected, whereas e.g. SELECT works as expected.
However I do not remember running into this in the last couple of months 
but this was maybe just luck :)
What has to be investigated, too, is if it happens with the same db user 
(role) accessing a table through QGIS and pgadmin. Background is I have 
dozens of db roles accessing the db with QGIS and as said above did not 
run into this problem recently when administrating the db with pgadmin.
Anybody has an idea what the reason is? Does QGIS lock a table so it 
cannot be altered?

Bernhard
>
>> it happens that pgadmin/psql operations remain "freezed", then when
>> closing qgis they immediately start and finish as expected.
>
> confirmed.
>
> thanks.
>
> - --
> Paolo Cavallini - www.faunalia.eu
> Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
> Comment: Using GnuPG with Icedove - http://www.enigmail.net/
>
> iEYEARECAAYFAlNGMwoACgkQ/NedwLUzIr48IACeKi0zj6R1iMIo+8JzQa4MAQEu
> NYsAoIEZtgt9Q1skPwfSJk5dtfgRd5xA
> =ubt+
> -----END PGP SIGNATURE-----
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> __________ Information from ESET Security, version of virus signature database 9658 (20140410) __________
>
> The message was checked by ESET Security.
>
>      part000.txt - is OK
>
> http://www.eset.com
>
>




__________ Information from ESET Security, version of virus signature database 9658 (20140410) __________

The message was checked by ESET Security.

    part000.txt - is OK

http://www.eset.com