Re: pg_dump with postgis extension dumps rules separately - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump with postgis extension dumps rules separately
Date
Msg-id 21430.1370100665@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump with postgis extension dumps rules separately  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2013-06-01 11:07:53 -0400, Tom Lane wrote:
>> I don't like this approach much.
>> 
>> 1. It does nothing to fix the issue in *existing* databases, which
>> won't have pg_depend entries like this.

> Well, you can now write an extension upgrade script that adds the
> missing dependencies. To me that sounds better than letting it fiddle
> with pg_depend.

Per my point #2, that would be the wrong solution, quite aside from the
wrongness of dumping the fixup burden on the extension author.  For one
thing, the extension author has no idea whether his script is being
loaded into a database that has this patch.  If it doesn't, adding a
command like this would cause the script to fail outright.  If it does,
then the command is unnecessary, since the patch also includes a code
change that adds the dependency.

But in any case, making rules act differently from other table
properties for this purpose seems seriously wrong.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_dump with postgis extension dumps rules separately
Next
From: Joe Conway
Date:
Subject: Re: pg_dump with postgis extension dumps rules separately