Hi Sylvain, On Mon, 16. Mar 2015 at 18:01:35 +0100, PIERRE Sylvain wrote: > With Postgis/QGIS configuration I can manage sequences on primary key when > editing new object (editing forms show a nextval(‘xxxxxxxxxx’::regclass) > formula in pk field) > With my Oracle/QGIS conf I can’t manage sequences, and editing failed when I > want to save. > Where is the problem? > Is it an Oracle provider issue ?
Not really. In PostgreSQL the sequence value is retrieved by a default expression. In Oracle sequences used to be retrieved and assigned to the new record using a before insert trigger. But in Oracle 12c you can also use default values to retrieve and assign the next sequence value. I suppose that works in QGIS too, but I don't currently have setup a 12c to verify. So unless you have 12c with a default value, you have to have a trigger to deal with assigning the key value. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS release manager (PSC) Germany IRC: jef on FreeNode
signature.asc
Description: Digital signature
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
