pgAdmin4 (v 4.11) SELECT * returns 'table_oid'
От | richard coleman |
---|---|
Тема | pgAdmin4 (v 4.11) SELECT * returns 'table_oid' |
Дата | |
Msg-id | CAGA3vBtY2Gfh_cW5rLVwcC7Q+m7feNkfxSEnXSY-mg5ET00Eeg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgAdmin4 (v 4.11) SELECT * returns 'table_oid'
Re: pgAdmin4 (v 4.11) SELECT * returns 'table_oid' |
Список | pgadmin-support |
'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
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
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;
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;
В списке pgadmin-support по дате отправления: