Error while trying to any FTS Object with name containing spaces - Mailing list pgadmin-hackers

From Dhiraj Chawla
Subject Error while trying to any FTS Object with name containing spaces
Date
Msg-id CAJgtxT7=5XKAf_PQ5qOe9+batd60xPNmDCWgWgvxvkaDQrcpVA@mail.gmail.com
Whole thread Raw
Responses Re: Error while trying to any FTS Object with name containing spaces  (Dave Page <dpage@pgadmin.org>)
List 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

pgadmin-hackers by date:

Previous
From: Dhiraj Chawla
Date:
Subject: pgAdmin3 crash when creating new FTS Configuration
Next
From: Vladimir Kokovic
Date:
Subject: frmQuery (multiple result sets support) - patch no.2