The following bug has been logged online:
Bug reference: 3255
Logged by: Bernd Fuhrmann
Email address: silverbanana@gmx.de
PostgreSQL version: 8.2.4
Operating system: Windows XP SP2
Description: Proper escaping missing
Details:
I just tried to use pgAdmin to create a database with a stupid name:
test"test
This doesn't work since sends this:
CREATE DATABASE "test"test"
WITH ENCODING='UTF8';
Obivously, if I just enter 'test"test' into the field it rather should have
sent this:
CREATE DATABASE "test""test"
WITH ENCODING='UTF8';
So I guess pg3Admin is missing proper escaping.
Btw. using the name test""test created the database I wanted, but that will
lead to a lot of other troubles when administrating that database with
pgAdmin.