I think I have been bit by Bug #4520 <https://redmine.postgresql.org/issues/4520?issue_count=196&issue_position=3&next_issue_id=4519&prev_issue_id=4525>. I hope there is a solution soon.
rik. On Sat, Jul 27, 2019 at 4:14 PM richard coleman <rcoleman.ascen...@gmail.com> wrote: > 'ello all, > > When running the following query: > > SELECT * FROM live.tbl_documents limit 10000; > > in pgAdmin4 it returns *no* output and switches to the Messages tab with > the following message: > > 'table_oid' > > > The same query against the same table in the same database run at the psql > prompt returns the records as expected. > > postgreSQL 10.3 > > using pgAdmin4 > Version > 4.11 > Copyright > Copyright (C) 2013 - 2019, The pgAdmin Development Team > Python Version > 3.6.8 (default, Jan 14 2019, 11:02:34) [GCC 8.0.1 20180414 (experimental) > [trunk revision 259383]] > Flask Version > 0.12.2 > Application Mode > Desktop > Current User > pgadm...@pgadmin.org > > Running on Chromium > Version 75.0.3770.90 (Official Build) Built on Ubuntu , running on Ubuntu > 18.04 (64-bit) > > Kubuntu 18.04. > > Table: > CREATE TABLE live.tbl_documents > ( > id character varying(50) COLLATE pg_catalog."default" NOT NULL, > company_no character varying(32) COLLATE pg_catalog."default", > tariff_id integer, > scac character(4) COLLATE pg_catalog."default", > type character varying(50) COLLATE pg_catalog."default" NOT NULL, > name character varying(200) COLLATE pg_catalog."default" NOT NULL, > filelocation character varying(200) COLLATE pg_catalog."default" NOT > NULL, > description character varying(200) COLLATE pg_catalog."default" NOT > NULL, > archive boolean NOT NULL DEFAULT false, > par_id character varying(50) COLLATE pg_catalog."default", > category character varying(250) COLLATE pg_catalog."default", > visible_in_vision boolean NOT NULL DEFAULT false, > tariffrequest_id character varying(50) COLLATE pg_catalog."default", > entered_on timestamp without time zone NOT NULL DEFAULT now(), > invoice_id character varying(40) COLLATE pg_catalog."default", > lastwritetime timestamp without time zone, > shipment_id character varying(40) COLLATE pg_catalog."default", > CONSTRAINT tbl_documents_pkey PRIMARY KEY (id), > CONSTRAINT tbl_documents_par_id_fkey FOREIGN KEY (par_id) > REFERENCES live.tbl_pars (par_id) MATCH SIMPLE > ON UPDATE NO ACTION > ON DELETE NO ACTION > ) > WITH ( > OIDS = FALSE > ) > TABLESPACE pg_default; > >
