Re: pg_dump with postgis extension dumps rules separately

On 2013-05-29 07:35:42 -0700, Joe Conway wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 05/29/2013 05:52 AM, Dimitri Fontaine wrote:
> > Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> >> On 2013-05-29 09:30:43 +0200, Dimitri Fontaine wrote:
> >>>> 2) How should we handle already installed extensions, which
> >>>> will still lack dependency records after this bugfix?
> >>>
> >>> I don't really see any other way here than providing an upgrade
> >>> script that will somehow re-attach those objects, either by
> >>> directly messing with pg_depends (that is, when there's a
> >>> systematic way to get the OIDs of the missing RULEs), or by
> >>> maybe doing a drop/create on the RULEs?
> >>
> >> Couldn't ALTER EXTENSION ... ADD ...; be brought up to speed to
> >> support this?
> >
> > I'll blame the Time Zone Difference Recovering. I felt like
> > missing something…
>
> Seems like the perfect idea, but is that something we would backpatch?

Sounds better to me than manually fiddling with pg_depend... We can't
really drop and recreate the RULEs, there might be dependencies
preventing that.

Greetings,

Andres Freund

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