[Qgis-user] manually change FID/OID

[Bernhard Ströbl]

Hi,

I have not tied this myself but what happens if you make a view in the 
db which orders your data by id like
CREATE VIEW ordered_view AS
SELECT * FROM table
ORDER BY id;
and load that into QGIS?

Bernhard

Am 27.03.2013 10:29, schrieb José Pedro Santos:
> I don't understand exactly why you want to change the ID number but be
> careful doing that, like Stefano said and correctly, you can corrupt the
> all table.
>
> Best Regards,
> Jose Santos
>
> ------------------------------------------------------------------------
> Date: Tue, 26 Mar 2013 18:45:12 +0100
> From: stefano.iacovella at gmail.com
> To: chris.roettger at web.de
> CC: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] manually change FID/OID
>
> Maybe I misunderstood what are you trying to do, just be aware that
> manually modifying FID or OID in a shapefile or geoDb feature class is
> likely to corrupt them.
> Cheers,
> Stefano
> Il giorno 26/mar/2013 18:40, "Christian Röttger" <chris.roettger at web.de
> <mailto:chris.roettger at web.de>> ha scritto:
>
>     Hi,
>
>     no, i want to do it the other way arround. the problem is that i
>     want to change the FID value, which is generated by arcgis or qgis
>     automatically (the grey numbers in the first column). i have already
>     a column with id values. i want to assign the FID/OID with their values.
>
>     Am 26.03.2013 17:07, schrieb José Pedro Santos:
>
>         Hi Christian,
>
>         Why you don't create a new column with the ID values that you
>         want? If
>         you want to edit some columns or rows you can use the Field
>         Calculator.
>
>         Best Regards,
>         José Santos
>
>         ------------------------------__------------------------------__------------
>         Date: Tue, 26 Mar 2013 16:59:08 +0100
>         From: chris.roettger at web.de <mailto:chris.roettger at web.de>
>         To: qgis-user at lists.osgeo.org <mailto:qgis-user at lists.osgeo.org>
>         Subject: [Qgis-user] manually change FID/OID
>
>         Hi,
>
>         i have the following problem: If i export a postgis db with qgis it
>         mixes up the rows. On the first position in the attribute table is a
>         value with id 2400 but should be 0 or 1
>         e.g.
>         id objectname
>         0 | 2400 | name 2400 ...
>         1 | 828 | name 828 ...
>
>         When i inspect the database, everything seems to be ok, as the
>         line with
>         id =1 shows up on the top position and id is set as primary key.
>         Has anybody an idea how i can get my table back in the right
>         order or
>         how to manually update the FID/OID with my id values?
>
>         I need that for an geotools importer which reads the FID and i cant
>         change the import parameters.
>
>         Thanks christian
>
>         _________________________________________________ Qgis-user
>         mailing list
>         Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>         http://lists.osgeo.org/__mailman/listinfo/qgis-user
>         <http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
>
>     _________________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>     http://lists.osgeo.org/__mailman/listinfo/qgis-user
>     <http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
>
> _______________________________________________ Qgis-user mailing list
> Qgis-user at lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>



__________ Information from ESET Mail Security, version of virus signature database 8166 (20130327) __________

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