Re: Error while trying to any FTS Object with name containing spaces

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Dhiraj Chawla <dhiraj(dot)chawla(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Error while trying to any FTS Object with name containing spaces
Date: 2012-10-21 16:26:28
Message-ID: CA+OCxowt+VNJSoatJUsi4P7DpoF5fgn5eSMfmrKJ3gLAz2BFrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, applied.

On Sat, Oct 20, 2012 at 11:33 AM, Dhiraj Chawla
<dhiraj(dot)chawla(at)enterprisedb(dot)com> wrote:
> Hi Dave,
>
> If a user creates any FTS Object such as configuration, parser, dictionary,
> etc. with name containing spaces such as "a b" and tries to drop it via
> pgAdmin application via context menu in object browser, the user gets an
> error saying, "Error: invalid syntax near b...". The problem is the object
> are not quoted in the sql query because of which we get this error. Attached
> is the patch that fixes this issue.
>
> Thanks,
>
> --
> regards,
>
> Dhiraj Chawla
> Software Engineer
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
>
> Phone: +91-20-30589522
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2012-10-23 11:33:33 Re: pgAdmin with SSHTunneling support
Previous Message Dave Page 2012-10-21 16:26:20 pgAdmin III commit: Ensure FTS object names are quoted if necessary whe