On Mon, Sep 16, 2013 at 1:25 AM, Satoshi Nagayasu <snaga@uptime.jp> wrote:
> How about adding new system view with new function which returns
> a single pg_controldata value in text type, and using a cast for
> each column in the view definition?
>
> CREATE VIEW pg_catalog.pg_controldata AS
> SELECT pg_controldata('control_version')::integer AS control_version,
> pg_controldata('catalog_version')::integer AS catalog_version,
> pg_controldata('system_identifier')::bigint AS system_identifier,
> ...
> pg_controldata('next_xlog_file')::char(25) AS next_xlog_file,
> ...
> pg_controldata('encoding')::text AS encoding;
>
> Given that the view can work like a SRF, and it allows us to retrieve
> all the values of pg_controldata with appropriate types in single
> record from the view:
I like this idea. I think having an easy way to get the values with
the right types will be a plus. But adding a separate function for
each field seems excessive, so I think this is a good compromise.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company