Thanks Ivan.
This line is now working for me:
DATA "the_geom FROM ten_points_layer using srid=26915"
-----Original Message-----
From: UMN MapServer Users List on behalf of ivan minc(ík
Sent: Sat 12/1/2007 5:02 PM
To: MAPSERVER-USERS@LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] PostGIS Layer Failing
I think this line DATA "the_geom FROM ten_points_layer using unique
the_geom"
should be DATA "the_geom FROM ten_points_layer using unique gid"
Ivan
William Kyngesburye wrote:
> Which version of PostGIS are you using? There is a bug in PostGIS
> 1.3.1 and SVN that was fixed a few days ago that affects Leopard.
> PostGIS had a function with a commonly used name, and this function
> was added to the Leopard libSystem. This gets used in PostGIS instead
> of its own, causing Postgres to crash.
>
> Either install PostGIS from the latest SVN, or install my latest
> PostGIS if you are using my binaries.
>
>
> If that's not the problem, try looking in the console and system logs,
> as well as the Apache logs. A library problem may just appear as an
> unidentified error at the PHP level, and digging into system logs may
> be needed to identify the problem.
>
>
> On Dec 1, 2007, at 1:52 PM, Fawcett, David wrote:
>
>> I am testing out a new install of PostGIS and MapServer on OS X
>> Leopard. I built a map file to display a simple ten point layer
>> coming from PostGIS.
>>
>> I get the following error:
>>
>> msDrawMap(): Image handling error. Failed to draw layer named
>> 'basemap'. prepare_database(): Query error. Couldnt recover from a
>> bad query: 'DECLARE mycursor BINARY CURSOR FOR SELECT
>> asbinary(force_collection(force_2d(the_geom)),'NDR'),the_geom::text
>> from ten_points_layer WHERE the_geom && setSRID('BOX3D(146545.5
>> 4814000,804891.5 5472346)'::BOX3D,
>> find_srid('','ten_points_layer','the_geom') )'
>>
>> Here is the layer definition:
>> LAYER
>> NAME basemap
>> STATUS DEFAULT
>> TYPE POLYGON
>> CONNECTIONTYPE POSTGIS
>> CONNECTION "host=localhost dbname=mydb user=myuser password=mypass
>> port=5432"
>> DATA "the_geom FROM ten_points_layer using unique the_geom"
>>
>> CLASS
>> COLOR 255 255 255
>> OUTLINECOLOR 181 181 181 #An OUTLINECOLOR with no COLOR gives
>> same effect as old POLYLINE
>> END
>>
>> PROJECTION
>> "init=epsg:26915"
>> END
>> END
>>
>> Any ideas? I am also having trouble getting QGIS to display the layer.
>>
>> Thanks,
>>
>> David.
>
> -----
> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
> http://www.kyngchaos.com/
>
> "Time is an illusion - lunchtime doubly so."
>
> - Ford Prefect
>
