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

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(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'
>
>
> 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;
>
>