[postgis-users] postgis

[nickthegreek-]

gello to everyone i need a  big .... what  i have done is..to load a shp file
in the postgresql in the table postgis...

in the mapfile i have the connectiontype and the connection and in the data
i have ' the_geoms from a file'..ok up now

the shp file has been saved in the database in
postgis->shecmas->public->tables..
when i select to see what this file has inside it shows the columns
gid,...... .....   and has put column the_geom

it has put the_geom automatically..the only column that added..
when i try to show this map i take this error and i don't know that to do
...pls helpme ..i have to give this exercise in monday

Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named 'canada
states'. in C:\ms4w\Apache\htdocs\canada.php on line 203

Warning: [MapServer Error]: prepare_database(): Error executing POSTGIS
DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR
SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
province WHERE the_geom && setSRID('BOX3D(-179.041698235478
25.406659782504,179.75431737052 89.1495117937299)'::BOX3D,
find_srid('','province','the_geom') )' Postgresql reports the error as
'ERROR: column "oid" does not exist LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^ ' More
Help: Error with POSTGIS data variable. You specified 'check your .map
file'. Standard ways of specifiying are : (1) 'geometry_column from
geometry_table' (2) 'geometry_column from (sub query) as foo using unique
column name using SRID=srid#' Make sure you put in the 'using unique column
name' and 'using SRID=#' clauses in. For more help, please see
http://postgis.refractions.net/documentation/ Mappostgis.c - version of Jan
in C:\ms4w\Apache\htdocs\canada.php on line 203

Warning: [MapServer Error]: msPOSTGISLayerRetrievePGVersion(): Error
executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select
substring(version() from 12 for (position('on' in version()) - 13)) in
C:\ms4w\Apache\htdocs\canada.php on line 203

Fatal error: Call to a member function saveImage() on a non-object in
C:\ms4w\Apache\htdocs\canada.php on line 204
-- 
View this message in context: http://www.nabble.com/postgis-tp16457583p16457583.html
Sent from the PostGIS - User mailing list archive at Nabble.com.