Postgres Pro
Downloads
Home   >   mailing lists

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

From Dimitri Fontaine
Subject Re: pg_dump with postgis extension dumps rules separately
Date
Msg-id m2obbu6j8h.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: pg_dump with postgis extension dumps rules separately  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: pg_dump with postgis extension dumps rules separately  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Tree view 
Andres Freund <andres@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…

Thanks, regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: GRANT role_name TO role_name ON database_name
Next
From: Ray Stell
Date:
Subject: Re: [GENERAL] pg_upgrade -u