| From: | Dhiraj Chawla <dhiraj(dot)chawla(at)enterprisedb(dot)com> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Error while trying to any FTS Object with name containing spaces |
| Date: | 2012-10-20 09:33:32 |
| Message-ID: | CAJgtxT7=5XKAf_PQ5qOe9+batd60xPNmDCWgWgvxvkaDQrcpVA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
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 | Content-Type | Size |
|---|---|---|
| pgadmin3_unable_to_drop_fts_objects_fix.patch | application/octet-stream | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Wilson | 2012-10-20 16:19:55 | Re: pgadmin crash - editing function body |
| Previous Message | Dhiraj Chawla | 2012-10-20 08:38:15 | pgAdmin3 crash when creating new FTS Configuration |