Re: pg_system_identifier()

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