WMS Time and PostGIS Problem

[uli mueller [geOps]]

Hi all

I have just started to implement the WMS time support with MapServer
4.1. My data come from PostGIS. Unfortunately MapServer cannot find the
time field I specified in wms_timeitem. I always get the following
service exception (extrat):

....prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual
query) statement:

'DECLARE mycursor BINARY CURSOR FOR
SELECT
QUAL::text,obst::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text
from tmp.lynxpt WHERE (date_trunc('day', obst) = '19960101') and
(the_geom && setSRID( 'BOX3D(3388284.99999994
5260274.99999989,3610085.00000005
5517475)'::BOX3D,find_srid('','tmp.lynxpt','the_geom') ))
'

Postgresql reports the error as 'ERROR: column "obst" does not exist ....

The same SQL statement works fine when run directly in Postgres.

Any ideas? Does MapServer expect the time field to have a special
Postgres type or can it be any ot the date/time types (timestamp, date,
time, with/without timezone...)?

Thanks, Uli

--
geOps GeoInformatics
D-79100 Freiburg