<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Eduin<br>
<br>
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??<br>
<br>
Martin F<br>
<br>
Eduin Yezid Carrillo Vega a écrit :
<blockquote
cite="mid:75b8f7010903090440s3e848898o4956e575460be99a@mail.gmail.com"
type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:jansen.marc@gmx.de"><jansen.marc@gmx.de></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">HI Martin,
Martin Fafard schrieb:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap="">AFAIK you can't. Maybe a table (created by your query) with a serial /
primary key helps.
--Marc
</pre>
<blockquote type="cite">
<pre wrap="">Martin F
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
<pre wrap="">
<hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a>
Version: 8.0.237 / Virus Database: 270.11.9/1990 - Release Date: 03/08/09 17:17:00
</pre>
</blockquote>
</blockquote>
</body>
</html>