Re: BUG #14587: Foreign constraint with newline blows up pg_restore catalogue

From: Sandro Santilli <strk(at)kbt(dot)io>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14587: Foreign constraint with newline blows up pg_restore catalogue
Date: 2017-03-10 17:47:42
Message-ID: 20170310174355.GA21663@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2017-03-10 16:23:34 Tom Lane wrote:
>
> Perhaps this should have been treated as a security issue, but the
> cat's out of the bag now. I think automated workflows involving -l
> are pretty rare anyway

PostGIS' upgrade procedure [1],[2] is actually based on pg_restore -l,
so maybe it's not so rare:

[1] http://postgis.net/docs/manual-2.3/postgis_installation.html#hard_upgrade
[2] https://trac.osgeo.org/postgis/browser/tags/2.3.2/utils/postgis_restore.pl.in#L117

--strk;

() Free GIS & Flash consultant/developer
/\ https://strk.kbt.io/services.html

Browse pgsql-bugs by date

  From Date Subject
Next Message diabloneo 2017-03-12 03:56:21 BUG #14588: Postgres process blocked on semop
Previous Message Tom Lane 2017-03-10 16:23:34 Re: BUG #14587: Foreign constraint with newline blows up pg_restore catalogue