| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Cc: | Michael Meskes <meskes(at)postgresql(dot)org> |
| Subject: | Re: ECPG gets embedded quotes wrong |
| Date: | 2020-10-22 17:34:24 |
| Message-ID: | 5118.1603388064@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wrote:
> Poking at this further, I noticed that there's a semi-related bug
> that this patch changes the behavior for, without fixing it exactly.
> That has to do with use of a string literal as "execstring" in ECPG's
> PREPARE ... FROM and EXECUTE IMMEDIATE commands. Right now, it
> appears that there is simply no way to write a double quote as part
> of the SQL command in this context.
In the other thread, 1250kv pointed out that you can use an octal
escape (\042) to get a quote mark. That's pretty grotty, but it
does work in existing ECPG releases as well as with this patch.
So now I think the best answer for this part is just to document that
workaround. Given the lack of complaints up to now, it's definitely not
worth the amount of trouble that'd be needed to have a cleaner solution.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2020-10-22 17:42:28 | Re: Deleting older versions in unique indexes to avoid page splits |
| Previous Message | Simon Riggs | 2020-10-22 17:11:58 | Re: Deleting older versions in unique indexes to avoid page splits |