[Postgres-xl-bugs] (no subject)

Răzvan-Sebastian Botez razvan.botez at gmail.com
Tue Aug 30 11:41:30 PDT 2016


Redirecting this from general to bugs:

Hello,

I am really new to Postgres-XL, and I have just created a testing cluster,
running postgres-xl-9.5r1.3.

It's set-up on three nodes, one node GTM, and two with both a Coordinator
and a Datanode on each.

I am planning on load balancing between these two nodes, but at the moment
I am just connecting and running SQL queries on the first coordinator.

While testing some basic commands, I created a a few testing databases, one
of which has a fully numeric name, "213", and one with a name that starts
with a digit, "123test". When trying to drop either of these, I get a
syntax error:

postgres=# DROP DATABASE "213";
ERROR:  syntax error at or near "213"

postgres=# drop database 123test;
ERROR:  syntax error at or near "123"
LINE 1: drop database 123test;

postgres=# drop database "123test";
ERROR:  syntax error at or near "123"

Dropping a database that has a name which starts with a letter works just
fine.

Would anyone know how to delete these databases? Am I doing something
wrong, or is this an issue with Postgres-XL?

Thanks,
Raz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20160830/e74a1c85/attachment.htm>


More information about the postgres-xl-bugs mailing list