Re: View to get all the extension control file details - Mailing list pgsql-hackers

From Robert Haas
Subject Re: View to get all the extension control file details
Date
Msg-id CA+Tgmob=mgdo4T5vGCuK-jiuJ79TQuPX-jDHoiagDnmVAMRZBg@mail.gmail.com
Whole thread Raw
In response to Re: View to get all the extension control file details  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: View to get all the extension control file details  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-hackers
On Wed, Oct 10, 2018 at 8:27 AM Haribabu Kommi <kommi.haribabu@gmail.com> wrote:
> Here is the patch as per the above discussion.

One potential problem with this is that we could add more control-file
attributes in the future, and it will be annoying if the view ends up
with a million columns, or if we ever have to rename them.  People who
have created objects that depend on those views may find that
pg_dump/restore or pg_upgrade fail, just as they do when we whack
around pg_stat_activity. pg_settings gets around that using an
EAV-like format.  I'm not sure that's the best solution here, but it's
something to think about.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Why we allow CHECK constraint contradiction?
Next
From: Tom Lane
Date:
Subject: Re: Why we allow CHECK constraint contradiction?