Re: Ambiguos OPERATOR items in pg_restore manifest file (was: [postgis-devel] utils/new_postgis_restore.pl)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org, rkottman(at)mpi-bremen(dot)de, PostGIS Development Discussion <postgis-devel(at)postgis(dot)refractions(dot)net>, Sebastian Groß <sgross(at)mpi-bremen(dot)de>
Subject: Re: Ambiguos OPERATOR items in pg_restore manifest file (was: [postgis-devel] utils/new_postgis_restore.pl)
Date: 2011-07-18 15:25:26
Message-ID: CA+Tgmoav90PqjwopTRy0hjBLEkaMrYBxKZhLkKuYf37-Y6G_NA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jul 12, 2011 at 9:18 AM, Sandro Santilli <strk(at)keybit(dot)net> wrote:
> Trying to exclude items from dumps of postgis-enabled databases
> we use pg_restore -l output and strip what we think belong to PostGIS.
>
> In doing so, Renzo found that for OPERATOR there are not enough
> informations to unambiguosly find it being part of PostGIS (see
> included mail snippet).
>
> Do you think this could be improved on the pg_restore side ?

In 9.1, we've added the concept of EXTENSIONs. I'm not sure whether
PostGIS is planning to take advantage of this mechanism, but it's
designed to solve exactly this problem.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2011-07-19 08:18:00 Re: BUG #6120: Problem running post-install step in Mac OS X Lion (GM)
Previous Message Robert Haas 2011-07-18 15:23:56 Re: BUG #6110: pg_hba.conf samehost does not work