Thread: pgsql: Backpatch dbmirror fix for escape handling.
pgsql: Backpatch dbmirror fix for escape handling.
From
momjian@postgresql.org (Bruce Momjian)
Date:
Log Message: ----------- Backpatch dbmirror fix for escape handling. > Upstream confirmed my reply in the last mail in [1]: the complete > escaping logic in DBMirror.pl is seriously screwew. > > [1] http://archives.postgresql.org/pgsql-bugs/2006-06/msg00065.php I finally found some time to debug this, and I think I found a better patch than the one you proposed. Mine is still hackish and is still a workaround around a proper quoting solution, but at least it repairs the parsing without introducing the \' quoting again. I consider this a band-aid patch to fix the recent security update. PostgreSQL gurus, would you consider applying this until a better solution is found for DBMirror.pl? Olivier, can you please confirm that the patch works for you, too? Backpatched to 8.0.X. Martin Pitt Modified Files: -------------- pgsql/contrib/dbmirror: DBMirror.pl (r1.11 -> r1.12) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbmirror/DBMirror.pl.diff?r1=1.11&r2=1.12)