Thread: Fix for RM3027: Do not SQLQuote parameter values for objects
Hi,
If user wants to set parameter values which requires quote
(like string values which have space/s in it or have special symbol ($) ) then
he has to input this values with quotes. (See below example)
Also all parameter values are case insensitive and while storing these values postgres
always store them in lower case (as per docs). So values which are in upper case won't need quotes.
Example:
1. User input
2. Generated SQL
3. Generated SQL (after saving properties.)
--
Harshal Dhumal
Sr. Software Engineer
Attachment
Thanks, patch applied.
On Fri, Feb 2, 2018 at 11:20 AM, Harshal Dhumal <harshal.dhumal@enterprisedb.com> wrote:
Hi,If user wants to set parameter values which requires quote(like string values which have space/s in it or have special symbol ($) ) thenhe has to input this values with quotes. (See below example)Also all parameter values are case insensitive and while storing these values postgresalways store them in lower case (as per docs). So values which are in upper case won't need quotes.Example:1. User input2. Generated SQL3. Generated SQL (after saving properties.)--Harshal DhumalSr. Software Engineer
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company