Ahhh, MapServer doesn't really care what the column is you specify with
USING UNIQUE, in fact Refractions suggest that you don't use oid. Add a
new unique SERIAL column to each table (call it GID) and specifiy that
column instead of oid in your MapFile DATA variable.<br>
<br>
Aaron<br><br><div><span class="gmail_quote">On 6/20/06, <b class="gmail_sendername">Ezequias Rodrigues da Rocha</b> <<a href="mailto:ezequias@recife.pe.gov.br">ezequias@recife.pe.gov.br</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
No,<br><br>The PostGIS driver on OpenJUMP does not takes care of it yet. My problem<br>is the Mapserver (a web server thar connects with a PostGIS database).<br><br>OpenJUMP can save and retrieve later, but mapserver needs this kind of
<br>data to exibit a map on the web or on OpenJUMP.<br><br>Thank you<br><br>Ezequias<br><br>Aaron Koning escreveu:<br>> Version 8.1 doesn't create the oid field by default. I'm not sure how<br>> to generate a system oid field, but you can always do: ALTER TABLE xyz
<br>> ADD COLUMN oid serial; I'm not sure if this fills in the oid value for<br>> each row, or whether you have to do that after the fact.<br>><br>> oid is a sort of system field that, when created by default, isn't
<br>> displayed with "\d". Not sure why.<br>><br>> When using JUMP, does a unique id field get created? With shp2pgsql<br>> GID is created and thats good enough for unique identification of rows...<br>
><br>> Aaron<br>><br>><br>> On 6/20/06, *Ezequias Rodrigues da Rocha* <<a href="mailto:ezequias@recife.pe.gov.br">ezequias@recife.pe.gov.br</a><br>> <mailto:<a href="mailto:ezequias@recife.pe.gov.br">
ezequias@recife.pe.gov.br</a>>> wrote:<br>><br>> Aaron,<br>><br>> When you tell new versions you mean 8.1 ?<br>><br>> Another question, why this field does not appears in a "\d" command ?
<br>> and how to generate this field if my application does not<br>> generated it ?<br>><br>><br>><br>> Regards<br>><br>><br>> Aaron Koning escreveu:<br>> > 'oid' is a database generated field containing unique values
<br>> (one for<br>> > each row). In previous versions of PostgreSQL it was created by<br>> > default, however in newer versions it is not generated by<br>> default. The<br>> > shp2pgsql loader creates a 'gid' field that also contains unique
<br>> > values, therefore the need for oid is moot ( i.e. use gid<br>> instead of oid).<br>> ><br>> > Aaron<br>> ><br>> > On 6/19/06, *Ezequias Rodrigues da Rocha* <
<br>> <a href="mailto:ezequias@recife.pe.gov.br">ezequias@recife.pe.gov.br</a> <mailto:<a href="mailto:ezequias@recife.pe.gov.br">ezequias@recife.pe.gov.br</a>><br>> > <mailto:<a href="mailto:ezequias@recife.pe.gov.br">
ezequias@recife.pe.gov.br</a><br>> <mailto:<a href="mailto:ezequias@recife.pe.gov.br">ezequias@recife.pe.gov.br</a>>>> wrote:<br>> ><br>> > Could someone tell me what oid field does ?
<br>> ><br>> > I am using JUMP to load data into PostGIS and it is not<br>> generating<br>> > this<br>> > king of column.<br>> ><br>> > I just think it is a problem is becouse didn't load the
<br>> > spatial_ref_sys<br>> > table yet.<br>> ><br>> ><br>> > Sincerely<br>> > Ezequias<br>> ><br>> > _______________________________________________
<br>> > postgis-users mailing list<br>> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <mailto:<a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a>><br>> > <mailto:<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <mailto:<a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a>>><br>> > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> > <
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>><br>> ><br>> ><br>> ><br>> ><br>> > --
<br>> > +--------------------------------------------<br>> > | Aaron Koning<br>> > | Information Technologist<br>> > | Prince George, BC, Canada.<br>> > +--------------------------------------------
<br>> > | <a href="http://datashare.gis.unbc.ca/fist/">http://datashare.gis.unbc.ca/fist/</a><br>> > | <a href="http://datashare.gis.unbc.ca/gctp-js/">http://datashare.gis.unbc.ca/gctp-js/</a><br>> > +--------------------------------------------
<br>> ><br>> ------------------------------------------------------------------------<br>> ><br>> > _______________________________________________<br>> > postgis-users mailing list
<br>> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <mailto:<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a>><br>> > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> ><br>><br>> --<br>> Ezequias Rodrigues da Rocha
<br>> <a href="http://ezequiasrocha.blogspot.com">http://ezequiasrocha.blogspot.com</a><br>> <a href="mailto:msn:ezequias@hotmail.com">msn:ezequias@hotmail.com</a> <mailto:<a href="mailto:msn">msn</a>:<a href="mailto:ezequias@hotmail.com">
ezequias@hotmail.com</a>><br>> "the worst of democracies is still better than the best of<br>> dictatorship"<br>><br>> _______________________________________________<br>> postgis-users mailing list
<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <mailto:<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a>><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br>><br>><br>> --<br>> +--------------------------------------------
<br>> | Aaron Koning<br>> | Information Technologist<br>> | Prince George, BC, Canada.<br>> +--------------------------------------------<br>> | <a href="http://datashare.gis.unbc.ca/fist/">http://datashare.gis.unbc.ca/fist/
</a><br>> | <a href="http://datashare.gis.unbc.ca/gctp-js/">http://datashare.gis.unbc.ca/gctp-js/</a><br>> <<a href="http://datashare.gis.unbc.ca/gctp-js/">http://datashare.gis.unbc.ca/gctp-js/</a>><br>> +--------------------------------------------
<br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br><br>--<br>Ezequias Rodrigues da Rocha
<br><a href="http://ezequiasrocha.blogspot.com">http://ezequiasrocha.blogspot.com</a><br><a href="mailto:msn:ezequias@hotmail.com">msn:ezequias@hotmail.com</a><br>"the worst of democracies is still better than the best of dictatorship"
<br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>+--------------------------------------------<br>| Aaron Koning<br>| Information Technologist<br>| Prince George, BC, Canada.
<br>+--------------------------------------------<br>| <a href="http://datashare.gis.unbc.ca/fist/">http://datashare.gis.unbc.ca/fist/</a><br>| <a href="http://datashare.gis.unbc.ca/gctp-js/">http://datashare.gis.unbc.ca/gctp-js/
</a><br>+--------------------------------------------