Jacolin Yves wrote:
> Sorry to not post a message before. But I confim that postgis doesn't like
> capital letter. I don't know if mapserver change something in the
> 'connection' parameter. But when I create a table in the postGIS database,
> with capital letter, the layername in the 'geometry_columns' table was in
> capital letter but the layer name (ie the name of the table) was in lower
> case !
>
Yes, but to correctly create table with capital letters is
postgis you should use this form:
CREATE TABLE "Table_With_Capital_Letters" (
..
);
SELECT AddGeometryColumn( 'public', 'Table_With_Capital_Letters',
'Geom', '1', MULTIPOLYGON, '2' );
This will work, but the problem is that mapserver doesn't always
use quoting.
Problem is that from this DB I need to server GML via WFS, and
features and attributes in official schema is with first capital
letter. Now I know that I can override attribute name in WFS but
it is lots of work.
Maybe in the future mapserver will be able to more correctly
use postgis.
Best regards,
Daniel Vencler
