Thread: pgAdmin4 (v 4.11) SELECT * returns 'table_oid'
'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;
On Sat, Jul 27, 2019 at 4:14 PM richard coleman <rcoleman.ascentgl@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'The same query against the same table in the same database run at the psql prompt returns the records as expected.postgreSQL 10.3using pgAdmin4Version
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.orgRunning on ChromiumVersion 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;
'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.3using pgAdmin4Version
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.orgRunning on ChromiumVersion 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;
Re: pgAdmin4 (v 4.11) SELECT * returns 'table_oid'; now not enoughvalues to unpack (expected 5, got 4)
From
Aditya Toshniwal
Date:
Hi Tony,
The official release of pgAdmin4 is 4.11. In 4.11-2, the dependency issue (pysocpg2) on apt was fixed.
So don't worry, you're on the latest.
On Sun, Aug 18, 2019 at 7:27 AM Tony Bazeley <tonyb@tonyb.id.au> wrote:
Thanks for the quick upgrade to fix this problem.I ran the upgrade to 4.11.2 through the package manager.But commands of the form select * from tablename now return: not enough values to unpack (expected 5, got 4)I noticed the the splash and about screens still referred to version 4.11 so did a complete reinstall:sudo apt --purge remove pgadmin4
sudo apt autoremoveand sudo apt-get install pgadmin4and now have:sudo apt list --installed | grep pga
pgadmin4-common/disco-pgdg,now 4.11-2.pgdg19.04+1 all [installed,automatic]
pgadmin4-doc/disco-pgdg,now 4.11-2.pgdg19.04+1 all [installed,automatic]
pgadmin4/disco-pgdg,now 4.11-2.pgdg19.04+1 amd64 [installed]However the problem still persistsI notice stackoverflow has some recent advice on actions for the desktop version but I'm not sure how to proceed with the server versionOn 11/8/19 8:28 am, Tony Bazeley wrote:I'm no python programmer and have installed 4.11 under Kubuntu 19.04My python version is:
~$ python3 -V
Python 3.7.3I installed psycopg2
~$ sudo pip3 install -U psycopg2And have a psycopg2 set of files in what seems to be an appropriate spot~$ ls -l /usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2
total 152
-rw-r--r-- 1 root root 68788 Jul 23 14:45 connection.py
-rw-r--r-- 1 root root 7750 Jul 23 14:45 cursor.py
-rw-r--r-- 1 root root 3549 Jul 23 14:45 encoding.py
-rw-r--r-- 1 root root 2259 Jul 23 14:45 generate_keywords.py
-rw-r--r-- 1 root root 12706 Jul 23 14:45 __init__.py
-rw-r--r-- 1 root root 9375 Jul 23 14:45 keywords.py
drwxr-xr-x 2 root root 4096 Aug 11 00:02 __pycache__
-rw-r--r-- 1 root root 20569 Jul 23 14:45 server_manager.py
-rw-r--r-- 1 root root 8416 Jul 23 14:45 typecast.pyBut the problem persistsUsing the tablename>view/edit/data facility works, but using the same sql in the Query Tool returns 'table_oid'Any thoughts on what to do next would be greatly appreciatedTonyOn 28/7/19 6:27 pm, Dave Page 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.3using pgAdmin4Version
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.orgRunning on ChromiumVersion 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;
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
Re: pgAdmin4 (v 4.11) SELECT * returns 'table_oid'; now not enoughvalues to unpack (expected 5, got 4)
From
Aditya Toshniwal
Date:
On Mon, Aug 19, 2019 at 11:05 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Tony,The official release of pgAdmin4 is 4.11. In 4.11-2, the dependency issue (pysocpg2) on apt was fixed.So don't worry, you're on the latest.On Sun, Aug 18, 2019 at 7:27 AM Tony Bazeley <tonyb@tonyb.id.au> wrote:Thanks for the quick upgrade to fix this problem.I ran the upgrade to 4.11.2 through the package manager.But commands of the form select * from tablename now return: not enough values to unpack (expected 5, got 4)
Regarding this, kindly raise a bug here - https://redmine.postgresql.org/projects/pgadmin4/issues/new with sample query or screenshot.
I noticed the the splash and about screens still referred to version 4.11 so did a complete reinstall:sudo apt --purge remove pgadmin4
sudo apt autoremoveand sudo apt-get install pgadmin4and now have:sudo apt list --installed | grep pga
pgadmin4-common/disco-pgdg,now 4.11-2.pgdg19.04+1 all [installed,automatic]
pgadmin4-doc/disco-pgdg,now 4.11-2.pgdg19.04+1 all [installed,automatic]
pgadmin4/disco-pgdg,now 4.11-2.pgdg19.04+1 amd64 [installed]However the problem still persistsI notice stackoverflow has some recent advice on actions for the desktop version but I'm not sure how to proceed with the server versionOn 11/8/19 8:28 am, Tony Bazeley wrote:I'm no python programmer and have installed 4.11 under Kubuntu 19.04My python version is:
~$ python3 -V
Python 3.7.3I installed psycopg2
~$ sudo pip3 install -U psycopg2And have a psycopg2 set of files in what seems to be an appropriate spot~$ ls -l /usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2
total 152
-rw-r--r-- 1 root root 68788 Jul 23 14:45 connection.py
-rw-r--r-- 1 root root 7750 Jul 23 14:45 cursor.py
-rw-r--r-- 1 root root 3549 Jul 23 14:45 encoding.py
-rw-r--r-- 1 root root 2259 Jul 23 14:45 generate_keywords.py
-rw-r--r-- 1 root root 12706 Jul 23 14:45 __init__.py
-rw-r--r-- 1 root root 9375 Jul 23 14:45 keywords.py
drwxr-xr-x 2 root root 4096 Aug 11 00:02 __pycache__
-rw-r--r-- 1 root root 20569 Jul 23 14:45 server_manager.py
-rw-r--r-- 1 root root 8416 Jul 23 14:45 typecast.pyBut the problem persistsUsing the tablename>view/edit/data facility works, but using the same sql in the Query Tool returns 'table_oid'Any thoughts on what to do next would be greatly appreciatedTonyOn 28/7/19 6:27 pm, Dave Page 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.3using pgAdmin4Version
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.orgRunning on ChromiumVersion 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;
--Thanks and Regards,Aditya ToshniwalSoftware Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"