[Qgis-developer] QGIS choosing invalid primary key column

Ivan Mincik ivan.mincik at gmail.com
Mon Jun 11 07:05:05 PDT 2012


On 06/11/2012 12:39 PM, Ivan Mincik wrote:
>> That's removed in 1.8.
> 
> I am thinking about 1.7 fix to update column query
> (QgsPostgresProvider::getPrimaryKey) to return primary key column first
> by adding ordering by 'indisprimary' column:
> 
> select indkey from pg_index where indisunique and
> indrelid=regclass('"vranov"."v_budovy"')::oid and indpred is null order
> by indisprimary desc

It seems that it fixed the problem. Patch attached for reference.
Is there any chance of releasing 1.7.5 ? Should I create pull request ?


-- 
Ivan Mincik
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pg-pk-detection-fix.patch
Type: text/x-patch
Size: 729 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20120611/3d6dd5a1/attachment-0001.bin>


More information about the Qgis-developer mailing list