Search Postgresql Archives

Re: Is it typo in pg_stat_replication column name in PG 9.4 ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, May 18, 2014 at 02:10:53PM +0530, Raghavendra wrote:
> Hi,
> 
> PostgreSQL 9.4 document for pg_stat_replication view mentions column name as
> "backend_xid", whereas when a view described it shows column name as
> "backend_xmin".
> http://www.postgresql.org/docs/devel/static/monitoring-stats.html#
> PG-STAT-REPLICATION-VIEW
> 
> postgres=# select version();
> -[ RECORD 1 ]
> ------------------------------------------------------------------------------------------------------------
>  version | PostgreSQL 9.4beta1 on x86_64-unknown-linux-gnu, compiled by gcc
> (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
> 
> postgres=# \d pg_stat_replication
>           View "pg_catalog.pg_stat_replication"
>       Column      |           Type           | Modifiers
> ------------------+--------------------------+-----------
>  pid              | integer                  |
>  usesysid         | oid                      |
>  usename          | name                     |
>  application_name | text                     |
>  client_addr      | inet                     |
>  client_hostname  | text                     |
>  client_port      | integer                  |
>  backend_start    | timestamp with time zone |
>  backend_xmin     | xid                      |
>  state            | text                     |
>  sent_location    | pg_lsn                   |
>  write_location   | pg_lsn                   |
>  flush_location   | pg_lsn                   |
>  replay_location  | pg_lsn                   |
>  sync_priority    | integer                  |
>  sync_state       | text                     |
> 
> Is it a typo in pg_stat_replication view column ?

This has been fixed by this commit:

	commit eb56812144bb310f7cb2f63e53d6d58f30df95b5
	Author: Fujii Masao <fujii@xxxxxxxxxxxxxx>
	Date:   Mon May 19 17:03:30 2014 +0900
	
	    Fix incorrect column name in pg_stat_replication document.
	
	    Fabrízio de Royes Mello

-- 
  Bruce Momjian  <bruce@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux