Re: BUG #4908: escaping and dollar quotes: "ERROR: unterminated string"

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Or you could turn on standard_conforming_strings if you'd prefer not
> to deal with escapes.

That doesn't help with this, because of the separate pgpgsql parser:

ccdev=> select version();
version
-----------------------------------------------------------------------------------------------------
PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20070115 (SUSE Linux)
(1 row)

ccdev=> show standard_conforming_strings ;
standard_conforming_strings
-----------------------------
on
(1 row)

ccdev=> create or replace function temp() returns text language
plpgsql
AS $$
begin
return '\';
end; $$;
ERROR: unterminated string
CONTEXT: compile of PL/pgSQL function "temp" near line 2

-Kevin