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