Thread: [pgadmin-hackers] [pgAdmin4][PATCH] To fix the issue in server stats sql (PPAS9.2)

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

Attachment
Thanks - patch applied.

On Tue, May 16, 2017 at 4:43 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.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@postgresql.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