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

Error while trying to any FTS Object with name containing spaces

From
Dhiraj Chawla
Date:
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

Attachment

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

From
Dave Page
Date:
Thanks, applied.

On Sat, Oct 20, 2012 at 11:33 AM, Dhiraj Chawla
<dhiraj.chawla@enterprisedb.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@postgresql.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