Обсуждение: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?

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!

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

On Mon, May 19, 2014 at 10:05 AM, Fabrízio de Royes Mello
<fabrizio@timbira.com.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