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

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Fabrízio Mello <fabriziomello(at)gmail(dot)com>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?
Date: 2014-05-19 08:12:32
Message-ID: CAHGQGwFkWuYSbUFGTo-nscZnD2KRV6+erZneOjk=+BWaMthf6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, May 19, 2014 at 10:05 AM, Fabrízio de Royes Mello
<fabrizio(at)timbira(dot)com(dot)br> wrote:
> On 18-05-2014 05:40, 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 ?
>>
>
> Hi,
>
> I think this is an incorrect list... moving to pgsql-hackers
>
> And yes, this seems to be a typo. Patch attached!

Thanks! Applied.

Regards,

--
Fujii Masao

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2014-05-19 08:24:57 Re: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?
Previous Message Dean Rasheed 2014-05-19 08:02:54 Re: 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION

Browse pgsql-hackers by date

  From Date Subject
Next Message Raghavendra 2014-05-19 08:24:57 Re: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?
Previous Message David Rowley 2014-05-19 06:45:20 Re: Allowing join removals for more join types