Re: [pgAdmin4][PATCH] To fix the issue in server stats sql (PPAS9.2)

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][PATCH] To fix the issue in server stats sql (PPAS9.2)
Date: 2017-05-17 14:53:28
Message-ID: CA+OCxow8MGes5FxkOgemrj1GPVwOHe-hfMY_XK9p6Eht+KQdrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks - patch applied.

On Tue, May 16, 2017 at 4:43 PM, Murtuza Zabuawala <
murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:

> Hi,
>
> PFA minor patch to fix the in server stats sql where it was fails to
> execute because it is not able to concat inet (type) when using with ||
> operator.
>
> *Fails:*
> select client_addr || ':' || client_port from pg_stat_activity
>
> *Works:*
> select client_addr::text || ':' || client_port from pg_stat_activity
>
> Fixes RM#1831
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2017-05-17 14:57:42 pgAdmin 4 commit: Improve error handling in cases where the user tries
Previous Message Dave Page 2017-05-17 14:53:17 pgAdmin 4 commit: Fix server stats display for EPAS 9.2, where inet nee