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