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

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: 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:24:57
Message-ID: CA+h6AhizuVM8Hscj-M-Kqg9NaWXuhUKiaRZoG9X2F6_NNwExjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On Mon, May 19, 2014 at 6:35 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
>
> Noted..! Thank you. I will take care in my future posting.

​--Raghav​

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
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message image 2014-05-19 13:17:57 Re: Psycopg2 : error message.
Previous Message Fujii Masao 2014-05-19 08:12:32 Re: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2014-05-19 09:18:08 Re: 9.4 beta1 crash on Debian sid/i386
Previous Message Fujii Masao 2014-05-19 08:12:32 Re: Re: [GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?