Re: pgAdmin4 (v 4.11) SELECT * returns 'table_oid'

> On 27 Jul 2019, at 21:14, richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)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
> pgadmin4(at)pgadmin(dot)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;
>