Ticket #4206 (new defect)
Opened 15 months ago
Schema name should not contain capital letters (Like "MySchema")
| Reported by: | sdikiy | Owned by: | colivier |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | TinyOWS | Version: | unspecified |
| Severity: | normal | Keywords: | |
| Cc: |
Description
.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
...
Note: See
TracTickets for help on using
tickets.
