[Qgis-user] Why does QGis autoincrement the integer key?

Bernhard Ströbl bernhard.stroebl at jena.de
Fri Oct 18 01:49:10 PDT 2013


Hi,

please update QGIS to the current version (2.0). Then your problem will 
be gone

Bernhard

Am 18.10.2013 10:45, schrieb F T:
> Hello,
>
> Is there a way to avoid that QGis autoincrement the integer key of a
> Postgis table?
>
> I have a simple Postgis table that has a valuable integer key.
> CREATE TABLE test.arret
> (
>    geom geometry,
>    ide integer NOT NULL,
>    nom_arret character varying(36),
>    CONSTRAINT arret_pkey PRIMARY KEY (ide),
>    CONSTRAINT enforce_dims_geom CHECK (st_ndims(geom) = 2),
>    CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POINT'::text
> OR geom IS NULL),
>    CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 2154)
> )
> WITH (
>    OIDS=TRUE
> );
>
> I want to enter the value of the key when I create a new point and it is
> not possible with QGis (1.7.4).
> When I create a new point and give it a value ide=1664, when the point is
> saved in the database, the key is auto incremented and my value is ignored.
>
> This behavior is not logical
> Is there a way to put and integer key the value that is needed?
>
> Thanks for your help
>
> Fabrice
>
>


__________ Information from ESET Mail Security, version of virus signature database 8933 (20131018) __________

The message was checked by ESET Mail Security.
http://www.eset.com





More information about the Qgis-user mailing list