[Postgres-xl-bugs] (no subject)

Răzvan-Sebastian Botez razvan.botez at gmail.com
Thu Sep 1 02:26:33 PDT 2016


Thanks for the patch, I'll give it a go and let you know if I have any more
issues with this.

Razvan

On 30 August 2016 at 19:56, Pavan Deolasee <pavan.deolasee at gmail.com> wrote:

>
>
> On Wed, Aug 31, 2016 at 12:11 AM, Răzvan-Sebastian Botez <
> razvan.botez at gmail.com> wrote:
>
>> 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 for the report. This looks like a bug. We should really be quoting
> database names while sending down commands to the remote node. Attached
> patch fixes this particular problem for me, but I'll look at other possible
> places where we might have missed quoting special names.
>
> Thanks,
> Pavan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20160901/9e4a207f/attachment.htm>


More information about the postgres-xl-bugs mailing list