[postgis-users] OGR2OGR Uppercase/Lowercase

[san at cobalt.rmnet.it]

Horst.Duester wrote:
> Hi,
> 
> I'm faced with an uppercase/lowercase problem. After shape file import to
> Postgresql with OGR2OGR all shape file based column names were stored
> uppercase. Postgresql isn't able to process columns with uppercase names.
> How to handle this problem? Any hint????

PostgreSQL IS able to process uppercase names, PostGIS IS NOT.

I went two times through the process of patching postgis.sql.in,
shp2pgsql.c and collaterally mappostgis.c from mapserver.
I had to do it the second time because Jeff asked me to on
25 March 2002 ( at the time he tried to apply my first patches
the CVS version was far too different from the last distributed 
version I made the patches from ).

Also the second patch is still waiting to be applied, but I'm afraid
it won't work now for the same reason. The corrections are pretty
simple, if you want to take a look at them the patches are at:
http://cobalt.rmnet.it/~san/postgis - they just quote all used
names so to permit upper/lower case but also spaces and other
otherwise unusable characters.

I hope Jeff Lounsbury and Dave Blasby will have time to add
these corrections themself, couse it seems to me that the 
process of sending patches is not practical in this case ...

--san