Flavio,
I think that if you have CONNECTIONTYPE OGR, the connection string
must have "PG:" (unlike the native mapserver Postgres connections?):
CONNECTIONTYPE ogr
CONNECTION "PG:dbname='testdb' host=GSERVER1 port=5432 user='test'
password='test' sslmode=disable"
If this works let me know, and I'll change the join documentation
Best Regards,
Brent Fraser
On 11/29/2010 7:43 AM, flaviocarmo wrote:
Hi,
I need to make a layer with a join between a shapefile and a non-spatial
table, stored on PostgreSQL. I've found this documentation
(http://mapserver.org/mapfile/join.html) but i could make it work, so, can u
guys help me looking at this configuration and tell me whats wrong?
LAYER
NAME "join_shape"
TYPE POLYGON
STATUS DEFAULT
DATA "join_shapefile.shp"
CLASS
NAME "Joined Shapes"
STYLE
OUTLINECOLOR 120 120 120
COLOR 0 30 255
END
END
TOLERANCE 20
JOIN
NAME "teste"
CONNECTION "dbname='testdb' host=GSERVER1 port=5432
user='test'
password='test' sslmode=disable"
CONNECTIONTYPE ogr
TABLE '"test"."nonspatial"'
FROM "code"
TO "code"
TYPE ONE-TO-ONE
END
END # layer
In this layer, i want to show only the geometrys in the shapefile
"join_shapefile.shp" that have a CODE column that is the same the CODE
column in the test.nonspatial table, stored on Postgre.
That is possible?
Thanks again
Regards,
Flavio Carmo
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users