Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl - Mailing list pgsql-bugs

From Martin Pitt
Subject Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl
Date
Msg-id 20060627202850.GA5160@piware.de
Whole thread Raw
Responses Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl
Re: Bug#372115: Last security update of postgresql-contrib
Re: Bug#372115: Last security update of postgresql-contrib
List pgsql-bugs
Hi PostgreSQL gurus, hi Olivier,

Martin Pitt [2006-06-16  0:15 +0200]:
> 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?

Thank you,

Martin

--
Martin Pitt        http://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?

Attachment

pgsql-bugs by date:

Previous
From: "Dave Page"
Date:
Subject: Re: BUG #2499: Error Message pgAdmin III
Next
From: Tom Lane
Date:
Subject: Re: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl