have you tried creating a sequence and then using nextval(sequence_name) to get a primary key?
Andreas On Mon, March 9, 2009 4:10 pm, Martin Fafard wrote: > Eduin > > Thank you for the answer but it doesn't work. Since I create new objects > from a view (polygonize), it seem to be impossible to create a unique id > in this view for these objects. Someone else have ever aggregate geom in > a view to see it in qgis or other viewer?? > > Martin F > > Eduin Yezid Carrillo Vega a écrit : >> If your postgresql version is 8.0 or less you can use OID fields as >> key identifier. >> >> CREATE VIEW myview AS SELECT oid AS gid, the_geom FROM mytable; >> >> In postgresql 8.3 you can force oid creation if WITH OIDS is specified >> when the table is created >> >> >> Eduin Yesid Carrillo Vega >> Ingeniero Civil, Esp. Sistemas de Información Geográfica >> Centro de Investigación y Desarrollo en Información Geográfica >> Instituto Geográfico Agustín Codazzi - IGAC >> Cr 30 48-51 >> Tel +57 1 3694000 ext 4593 >> Bogotá D.C., Colombia >> >> >> >> On Mon, Mar 9, 2009 at 2:43 AM, Marc Jansen <[email protected]> wrote: >> >>> HI Martin, >>> >>> >>> Martin Fafard schrieb: >>> >>>> Hi >>>> >>>> I polygonize linestrings in a view to see the result in qgis. But qgis >>>> need gid. How can I create the gid column after an aggregate function >>>> in a >>>> view? >>>> >>> AFAIK you can't. Maybe a table (created by your query) with a serial / >>> primary key helps. >>> >>> --Marc >>> >>> >>> >>> >>>> Martin F >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>> >>> ------------------------------------------------------------------------ >>> >>> >>> No virus found in this incoming message. >>> Checked by AVG - www.avg.com >>> Version: 8.0.237 / Virus Database: 270.11.9/1990 - Release Date: >>> 03/08/09 17:17:00 >>> >>> > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
