This is a bug and already reported. Ref: https://redmine.postgresql.org/issues/4439
On Thu, 18 Jul 2019, 20:46 Dave Irwin, <dhirwi...@gmail.com> wrote: > When I select a table, right-click and select View/Edit Data > All > Rows (there are only 28 rows in this table) I get the following error > in PGAdmin4: > > Not connected to the server or the connection to the server has been > closed. > > I've seen this happen in multiple different versions of PGAdmin4 but > am currently running 4.10. I've tried from several different > workstations and all exhibit the same problem. I am currently running: > > Version > 4.10 > Copyright > Copyright (C) 2013 - 2019, The pgAdmin Development Team > Python Version > 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 21:26:53) [MSC v.1916 32 bit > (Intel)] > Flask Version > 1.0.2 > Application Mode > Desktop > > I'm connecting to a Postgres 11.2 server on CentOS: > > PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-36), 64-bit > > Everything else in PGAdmin looks like it's loading fine; statistics, > DB listing, table listing, etc. I suspect that it might be something > with this particular table as I can view other tables just fine. > Here's the table schema: > > CREATE TABLE public.entityconfig_section > ( > agency character varying(32) COLLATE pg_catalog."default" NOT NULL, > id character varying(48) COLLATE pg_catalog."default" NOT NULL, > entity_as_json json NOT NULL, > last_update timestamp without time zone, > CONSTRAINT section_agency_id_pri_key PRIMARY KEY (agency, id) > ) > WITH ( > OIDS = FALSE > ) > TABLESPACE pg_default; > > Let me know if there's any additional information that's needed. > > Thanks, > Dave > > >
