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

[F T]

Hello Bernhard

I just remember that I asked this question in may 2012 (you already
answered me, thanks ! in 2012 it had been fixed in the dev version).

I'm sorry for posting twice the same question...
But I am delighted that this pb is solved !

I will follow your advice, it's time to update to QGis 2.0 !

Thanks

Fabrice



2013/10/18 Bernhard Ströbl <bernhard.stroebl at jena.de>

> 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
>
>
> ______________________________**_________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/qgis-user<http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131018/938943c0/attachment.html>