Re: pg_dump with postgis extension dumps rules separately

On 2013-06-01 11:31:05 -0400, Tom Lane wrote:
> 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.

What's your proposal to fix this situation then?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services