[postgis-users] postgis 0.8 and mapserver known issues ?

[Daniel Faivre]

Hi,

I've just installed postgis 0.8 from cvs. Is there known issues with 
MapServer 4.0 ?
I get a bug with a very simple test: unable to load postgis layers, even 
with applications that have worked perfectly with previous version (0.7.5).

Here is a very short php test code:

dl('php_mapscript.so');
$Map = ms_newMapObj('/var/www/cartoserver/mapfiles/test/test8.map');
$map_img = $Map->draw();
$imgurl = $map_img->saveWebImage();
echo '<img src='.$imgurl.'>';

And here is a test mapfile:

NAME DEMO
STATUS ON
SIZE 410 400

EXTENT 700000 1900000 985000 2180000

UNITS METERS
IMAGECOLOR 255 255 255

WEB
  IMAGEPATH "/var/www/cartoserver/www-data/images/"
  IMAGEURL "/gfx/"
  LOG "/tmp/gmap.log" 
END

LAYER                # test
  NAME sharka_pep2002
  TYPE POLYGON
  DEBUG ON 
  CONNECTIONTYPE postgis
  CONNECTION "user=www-data dbname=lutranet"
  DATA "test_geom from test"                # a layer with just one 
simple POLYGON: SRID=-1;POLYGON((10 10,20 10,20 20,10 20,10 10))
  STATUS ON
  CLASS
    NAME "test"
    COLOR 64 196 64
    OUTLINECOLOR 0 128 0
  END
END

END #Map File

I wonder where I could have done a mistake ? Where the (possible) bug 
may be ? PostGIS seems to work fine alone, and Mapserver too. Apache 
logs reports that:
NOTICE:  Error occurred while executing PL/pgSQL function find_srid
NOTICE:  line 27 at select into variables

But in psql, find_srid() seems to work well ...

Any idea to debug this would be greatly appreciated,

Thanks,

-- 
Daniel Faivre
Ohceo - Camptocamp
04 79 75 28 19
180 rue du Genevois
73000 Chambéry le Haut