[mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?

[Saka Royban]

Thanks alot
you are right. although i could understand from error message to have a OID column (it is gid in my table), my mistake was about ignoring 'USING' in 'USING UNIQUE gid).
thanks again to help me




________________________________
From: Dan Little <danlittle at yahoo.com>
To: Venkat Rao Tammineni <vtammineni at roulacglobal.com>; Saka Royban <srph124 at yahoo.com>; MapServer <mapserver-users at lists.osgeo.org>
Sent: Thursday, January 15, 2009 10:17:06 PM
Subject: Re: [mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?


Newer versions of Postgres do not automatically create an OID column, as it was a limited 32-bit construct.

Try add "using unique XXX" where XXX is the column name of the primary key (or at least a unique key).  If you've uploaded the layer from a shapefile using ogr2ogr you can use the column "ogc_fid"




________________________________
From: Venkat Rao Tammineni <vtammineni at roulacglobal.com>
To: Saka Royban <srph124 at yahoo.com>; MapServer <mapserver-users at lists.osgeo.org>
Sent: Thursday, January 15, 2009 5:33:35 AM
Subject: RE: [mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?

 
Hi,
 
  I think OID column may not be with your table…Can
you check that ..
 
Thanks
Venkat.
 
From:mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Saka
Royban
Sent: Thursday, January 15, 2009 3:36 PM
To: MapServer
Subject: [mapserver-users] newbie: Error in first atttempt to use
postgis with mapserver?
 
Hi everyone.
i've used workshop material of FOSS4G2007 (PostGIS workshop)to learn postgis
along with its data. but there is a problem
i got this error in first attempt to retrieve data from postgis:

msDrawMap(): Image handling error. Failed to draw layer named
'bc_municipality'. prepare_database(): Query error. Error declaring cursor:
ERROR: column "oid" does not exist LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^ With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
bc_municipality WHERE the_geom && setSRID('BOX3D(458426.1 260651.497368421,1943216.4 1373313.90263158)'::BOX3D,
find_srid('','bc_municipality ','the_geom') ) msPOSTGISLayerRetrievePGVersion():
Query error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)) 

i don't know what causes the problem although it sounds easy.
THX




-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090116/0f4f99e0/attachment.htm>