> On 27 Jul 2019, at 21:14, 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'
Upgrade psycopg2 to 2.8.3. pgAdmin has required 2.8.x for some time. > > 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; >
