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 <and...@2ndquadrant.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
