Opened 12 years ago

#4206 new defect

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
...

Change History (0)

Note: See TracTickets for help on using tickets.