Thread: Error while trying to any FTS Object with name containing spaces
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
Software Engineer
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Phone: +91-20-30589522
Attachment
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