[postgis-users] cannt connect in mapserver

[Chen Fu]

Richard:

Thank you! I never notice the -i option before.

But this time, postmaster output error information
when i execute shp2img.
Then i open the debug option -d 5

the debug info list below:

DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
LOG:  query: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d()),'NDR'),OID::text
from  WHERE  && 'BOX3D(-10 -10,10 10)'::BOX3D
ERROR:  parser: parse error at or near "WHERE" at
character 104
DEBUG:  AbortCurrentTransaction
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  child process (pid 2318) exited with exit code
0
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  child process (pid 2336) exited with exit code
0

I think something missed between the "where" and "&&".
But what i do in mapserver map file just is 

MAP
  NAME APPLE
  STATUS ON
EXTENT  -10 -10 10 10
UNITS METERS
SIZE 100 100
IMAGETYPE PNG

LAYER
CONNECTIONTYPE postgis
NAME "test"
CONNECTION "user=postgres password=postgres
dbname=chenfu host=localhost"
DATA "geom FROM test"
STATUS ON
TYPE LINE
END

END # Map File


Do you have any idea of this error?
Thanks in advance!


=====
Remote Scensing Satellite Ground Station
Chinese Academy of Science

_________________________________________________________
Do You Yahoo!? 
国内电邮用户反垃圾调查拉开帷幕
http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.tech.yahoo.com/zhuanti/laji/index.html