From: | Kaleb Akalework <kaleb(dot)akalework(at)asg(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: BUG #15632: Correctly escaped strings are mishandled in function |
Date: | 2019-02-11 18:28:00 |
Message-ID: | 29f41d36b0c6442c853eec253df061ea@asg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The actual error I get is error: -42 42601 syntax error at or near "SOLD". Because it removed the double single quote.
-----Original Message-----
From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Monday, February 11, 2019 1:19 PM
To: Kaleb Akalework <kaleb(dot)akalework(at)asg(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15632: Correctly escaped strings are mishandled in function
*** External email: Verify sender before opening attachments or links ***
On Mon, Feb 11, 2019 at 11:04 AM PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
> I'm working on a Java app, and I used prepared statements to create a
> function call to postgressql.
PostgreSQL (one s)...
> Inside my function I take these parameters and build a query like this
> WITH upd AS ( UPDATE topic$_dept SET topic_value = 'SOLD'' WHERE
> topic_value = 'SOLD' RETURNING 1 ) SELECT COUNT(*) FROM upd
I doubt this is a bug but rather likely you are not doing something correctly here. But since you don't show the function its impossible to say what.
> This will throw an error
How hard is it to include the actual error?
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Kaleb Akalework | 2019-02-11 18:32:43 | RE: BUG #15632: Correctly escaped strings are mishandled in function |
Previous Message | David G. Johnston | 2019-02-11 18:27:46 | Re: BUG #15632: Correctly escaped strings are mishandled in function |