https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-06-06T07:32:37ZQGIS Issue TrackingQGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418362013-06-06T07:32:37ZRegis Haubourgregis.haubourg@oslandia.com
<ul></ul><p>I guess you have things to tune in your search path, unclear what. <br />Default postgres search path of roles add a user variable:</p>
<p>ALTER ROLE groupe_lecture_seule<br /> SET search_path = "user", public, ouv, zon, ref, services, ext, dce, temp, inv;<br />COMMENT ON ROLE groupe_lecture_seule IS 'lecture_seule';</p>
<p>régis</p> QGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418382013-06-06T07:56:19ZBrett Zbrett@chartwell-consultants.com
<ul></ul><p>Thank you for the suggestion. My search path is the default: "$user", public. I've tried changing it around, but unfortunately this doesn't work. Regardless, the current setup of my PostgreSQL database allows me to add features without issue in QGIS 1.8, but not in QGIS 1.9, so it would seem it's either a change in behaviour from 1.8 to 1.9, or a bug.</p> QGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418442013-06-06T08:23:50ZBrett Zbrett@chartwell-consultants.com
<ul></ul><p>I've investigated this issue further, and found that regardless of the schema the table is in, I can only add features to tables that I own. I cannot add features to any table that another user owns, even if I have full privileges (INSERT, UPDATE, DELETE). I even tried this out with a new install of PostgreSQL and PostGIS 1.5 on a test server and had the same issue.</p> QGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418452013-06-06T08:26:07ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Brett Z wrote:</p>
<blockquote>
<p>I've investigated this issue further, and found that regardless of the schema the table is in, I can only add features to tables that I own. I cannot add features to any table that another user owns, even if I have full privileges (INSERT, UPDATE, DELETE). I even tried this out with a new install of PostgreSQL and PostGIS 1.5 on a test server and had the same issue.</p>
</blockquote>
<p>are you using a recent qgis master revision? a similar bug was fixed a while ago.</p> QGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418482013-06-06T08:36:22ZBrett Zbrett@chartwell-consultants.com
<ul></ul><p>I have tested this using the QGIS weekly build from June 3, downloaded here: <a class="external" href="http://qgis.org/downloads/weekly/">http://qgis.org/downloads/weekly/</a><br />I've also tested this today in Ubuntu 13.04 with the nightly build of QGIS (deb <a class="external" href="http://qgis.org/debian-nightly">http://qgis.org/debian-nightly</a> raring main) and had the same issue.</p>
<p>Giovanni Manghi wrote:</p>
<blockquote>
<p>Brett Z wrote:</p>
<blockquote>
<p>I've investigated this issue further, and found that regardless of the schema the table is in, I can only add features to tables that I own. I cannot add features to any table that another user owns, even if I have full privileges (INSERT, UPDATE, DELETE). I even tried this out with a new install of PostgreSQL and PostGIS 1.5 on a test server and had the same issue.</p>
</blockquote>
<p>are you using a recent qgis master revision? a similar bug was fixed a while ago.</p>
</blockquote> QGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418532013-06-06T09:54:54ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Priority</strong> changed from <i>High</i> to <i>Severe/Regression</i></li><li><strong>Target version</strong> set to <i>Version 2.0.0</i></li></ul><p>I can confirm the issue:</p>
<p>the owner of the table has the following capabilities:</p>
<p>Add Features, Delete Features, Change Attribute Values, Add Attributes, Delete Attributes, Fast Access to Features at ID, Change Geometries</p>
<p>while the non owner, but with all kind of grants results as:</p>
<p>Add Features, Delete Features, Change Attribute Values, Fast Access to Features at ID, Change Geometries</p>
<p>Seems a regression and so I'll tag this as blocker. Don't kill me if I'm wrong, please.</p> QGIS Application - Bug report #8005: Unable to Add Features to PostGIS Layer in Quantum GIS 1.9https://issues.qgis.org/issues/8005?journal_id=418582013-06-06T11:16:35ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>Fixed in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/6b0ce086f63830188af65e037012fddfff5cde67" title="fix activateDeactivateLayerRelatedActions (fixes #8005)">6b0ce086f63830188af65e037012fddfff5cde67</a>.</p>