Michael Fuhr <[EMAIL PROTECTED]> writes:
> How backward compatible should vacuumlo remain? This patch changes
> the string to E'...' but other ways would be to use dollar quotes
> or ESCAPE.
In this particular case, a far better answer is to replace
> ! strcat(buf, " AND s.nspname NOT LIKE 'pg\\\\_%'");
with
> ! strcat(buf, " AND s.nspname !~ '^pg_'");
which sidesteps the problem entirely and is more readable to boot.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
