[Qgis-user] Fwd: Fix table unique column

[Richard Duivenvoorde]

Hi,

not 100% sure, as I do not have an Oracle db around at this moment, but I think it works the same as in the Postgres dialog, see screendump:
in your list of tables in the connection dialog the cells in the column Feature id are changeable, click on it to be able to choose the right (integer?) column to be used as id. Same for setting the crs if it is not known from metadata.

Hope this helps,

Regards,

Richard Duivenvoorde


On 7/24/21 3:46 AM, Yamen Tekaji wrote:
> Hello..
> 
> Is my email getting through?
> I don't get any reply from anyone. 
> 
> Can you please help me with the below request?
> 
> Regards
> Yamen 
> 
> 
> ---------- Forwarded message ---------
> From: *Yamen Tekaji* <ytekaji at gmail.com <mailto:ytekaji at gmail.com>>
> Date: Wed, Jul 21, 2021, 3:57 PM
> Subject: Fix table unique column
> To: <qgis-user at lists.osgeo.org <mailto:qgis-user at lists.osgeo.org>>
> 
> 
> Dears,
> 
> I connected QGIS to Oracle DB which contains tables with GEOMETRY and spatial data.
> 
> When trying to add some tables to the layer window, I saw this error message:
> 
> 2021-07-13T16:48:15     WARNING    Primary key field 'INSERT_DATE' for view not unique.
> 
> 
> This INSERT_DATE is not my primary Key column. I have a column called ID which is the primary key. How can I tell QGIS which columns are the primary keys in the tables I want to add to layers?
> 
> 
> Please advise.
> 
> 
> Regards,
> 
> Yamen
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: id.jpeg
Type: image/jpeg
Size: 12927 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210724/895970ce/attachment.jpeg>