Re: [Qgis-user] Editing Oracle table - can't add feature

Ok, I made a PR to fix this here But in the same time, I saw that your first message was posted before the changes on Identity type ( merged the 13th January)

Re: [Qgis-user] Editing Oracle table - can't add feature

You're right I inverted the two function names. And I confirm I am on Oracle 11g so no handling of IDENTITY type. We should migrate to 12c someday, I will see if it's better then. Jérémie. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info:

Re: [Qgis-user] Editing Oracle table - can't add feature

Hi, I'm not sure to understand, did you invert "determineAlwaysGeneratedKeys" and "determinePrimaryKey" in your last sentence ? I guess that because all_tab_identity_cols table is only requested in "determineAlwaysGeneratedKeys" function. What is your version of Oracle ? Because

Re: [Qgis-user] Editing Oracle table - can't add feature

Hi, I have the spatial metadata in the both MDSYS.ALL_SDO_GEOM_METADATA and USER_SDO_GEOM_METADATA views. The SRID is well retrieved by Qgis in the add Oracle layer menu. But when I add the layer to the project QGIS tells me that the CRS is not defined (and it takes the default one). The other

Re: [Qgis-user] Editing Oracle table - can't add feature

Hello, I add my few knowledge about the srid definition. Currently oracle provider only check srid in the MDSYS.ALL_SDO_GEOM_METADATA view and not the MDSYS.USER_SDO_GEOM_METADATA. cf. https://github.com/qgis/QGIS/blob/master/src/providers/oracle/qgsoracleprovider.cpp#L2635 I made some changes

Re: [Qgis-user] Editing Oracle table - can't add feature

- - Messaggio originale - Da: "p.jeremie" A: "qgis-user@lists.osgeo.org" Inviato: Venerdì, 13 dicembre 2019 15:09:15 Oggetto: Re: [Qgis-user] Editing Oracle table - can't add feature Hello, I found that if the table con

Re: [Qgis-user] Editing Oracle table - can't add feature

Hello, I found that if the table contains geometry in 3D with SRID 2154, QGIS can't add the geometry in the table. If the geometry is 2D, it's ok. Still, I don't understand why I don't have the PRIMARY KEY column not filled whereas it is defined in the database... And why QGIS tells me that the

[Qgis-user] Editing Oracle table - can't add feature

Hello, I have an Oracle database with several tables with SDO_GEOMETRY columns in each. In Qgis, I can open every tables but for one I can't add features. The Edit button is NOT grey, I CAN click on it but the Add feature button is grey, therefore I can't add a new feature. What is strange when