ERROR: column 'oid' does not exist
Nigel Gilbert
n.gilbert at SURREY.AC.UK
Thu Jun 22 14:56:36 PDT 2006
I am trying to use mapserver with a PostGIS enabled database. However, I
get the mapserver error:
prepare_database(): Query error. Error executing POSTGIS DECLARE (the actual
query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(geom)),'XDR'),OID::text from world WHERE
geom && setSRID('BOX3D(-1333.33333333333 -1000,1333.33333333333
1000)'::BOX3D, find_srid('','world','geom') )'
Postgresql reports the error as 'ERROR: column "oid" does not exist '
I then noticed that the documentation for PostGIS, section 4.7.1 says that I
should create an oid index for the table I am wanting to display. So,
following the suggestion there, I tried, in the psql monitor:
create index world_oid_index on world ( oid );
ERROR: column "oid" does not exist
where 'world' is the table containing my geometry column. I haven't found
anything useful to help in either the PostGIS documenation or the PostgreSQL
docs.
What am I doing wrong?
Many thanks for your help!
--
Nigel
More information about the MapServer-users
mailing list