New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostGIS uppercase column names do not work #5579

Closed
cladisch opened this Issue Apr 10, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@cladisch

cladisch commented Apr 10, 2018

The PostGIS driver does not quote the geometry column name when doing the bounding box check. This breaks any table that uses uppercase letters in that column name:

msPostGISLayerWhichShapes(): Error (ERROR:  column "sp_geometry" does not exist
LINE 1: ...DR'),'hex') as geom,"MI_PRINX" from testgeo where SP_GEOMETR...
                                                             ^
) executing query: select encode(ST_AsBinary(ST_Force2D("SP_GEOMETRY"),'NDR'),'hex') as geom,"MI_PRINX" from testgeo where SP_GEOMETRY && ST_GeomFromText('POLYGON(4599989.97995992 100000,4599989.97995992 110000,4620010.02004008 110000,4620010.02004008 100000,4599989.97995992 100000))',31468)
msPostGISLayerWhichShapes(): Query error. Error executing query. Check server logs
@sdlime

This comment has been minimized.

Member

sdlime commented May 15, 2018

Closing, fix applied in 7.2 and master. --Steve

@sdlime sdlime closed this May 15, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment