Schema name should not contain capital letters (Like "MySchema")

[mapserver-bot]

Reporter: sdikiy
Date: 2012/02/22 - 13:16
Trac URL: http://trac.osgeo.org/mapserver/ticket/4206

.sql
CREATE SCHEMA "Foo";
CREATE TABLE "Foo".foo
(
  id serial NOT NULL,
  CONSTRAINT foo_pkey PRIMARY KEY (id)
);
SELECT AddGeometryColumn ('Foo','foo','the_geom',900913,'POINT',2)

tinyows.xml
...
schema="Foo"
name="foo"
...

TinyOWS.log
...
[SQL] SELECT pg_get_serial_sequence('Foo."foo"', 'id');
[ERROR] Unable to use pg_get_serial_sequence.
...

Postgresql.log
...
ERROR: schema "foo" does not exist
SQL state: 3F000
...

[mapserver-bot]

This is an automated comment

This issue has been closed due to lack of activity. This doesn't mean the issue is invalid, it simply got no attention within the last year. Please reopen with missing/relevant information if still valid.

Typically, issues fall in this state for one of the following reasons:

• Hard, impossible or not enough information to reproduce
• Missing test case
• Lack of a champion with interest and/or funding to address the issue