pgsql: Backpatch dbmirror fix for escape handling. - Mailing list pgsql-committers

From momjian@postgresql.org (Bruce Momjian)
Subject pgsql: Backpatch dbmirror fix for escape handling.
Date
Msg-id 20060706015734.20F979FA667@postgresql.org
Whole thread Raw
List pgsql-committers
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

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/contrib/dbmirror:
        DBMirror.pl (r1.10.6.1 -> r1.10.6.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbmirror/DBMirror.pl.diff?r1=1.10.6.1&r2=1.10.6.2)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Backpatch dbmirror fix for escape handling.
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Fix dbmirror for new backslash escaping: Martin Pitt [2006-06-16