Hi Murtuza

Uuups, sorry. Should have checked first. Thanks for the quick answer.

Cheers,
Alain

Von: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
Gesendet: Dienstag, 7. August 2018 9:12
An: Remund Alain
Cc: pgadmin-support@lists.postgresql.org
Betreff: Re: column "pid" does not exist

Hi,

pgAdmin4 supports PostgreSQL 9.2 and above.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com<http://www.enterprisedb.com/>
The Enterprise PostgreSQL Company
[https://drive.google.com/a/enterprisedb.com/uc?id=0B6jGeB3BfKRMV0t4MEp0YnZCTTA&export=download]

On Tue, Aug 7, 2018 at 12:39 PM, Remund Alain 
<alain.rem...@bertschi.com<mailto:alain.rem...@bertschi.com>> wrote:
Hi all

When I use pgAdmin 4, I have my log every few seconds filled with the following 
error message (see also attached "pgadmin4.log"):

2018-08-07 09:00:52,512: ERROR  pgadmin:   Failed to execute query 
(execute_dict) for the server #1- DB:postgres (Query-id: 842972):
Error Message:ERROR:  column "pid" does not exist
LINE 3:     pid,
            ^

I assume it is because the "pid" column in "pg_stat_activity" was named 
"procpid" on PostgreSQL 9.1 and older. pgAdmin 4 does not seem to check the 
PostgreSQL version and use the appropriate name, it just assumes it's talking 
to 9.2 or newer.
A possible candidate would be the "activity.sql" in 
"web\pgadmin\dashboard\templates\dashboard\sql\default"

PgAdmin:
Version 3.1
Python Version 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 16:07:46) [MSC v.1900 32 
bit (Intel)]
Flask Version 0.12.2
Application Mode Desktop
Current User pgadm...@pgadmin.org<mailto:pgadm...@pgadmin.org>

OS:
Windows 7

PostgreSQL: (select version();)
PostgreSQL 9.1.24lts2 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 
4.7.2-5) 4.7.2, 64-bit

Reply via email to