Re: [pgadmin-support] pgAdmin4 - Fetching Type Error

I'm running pgAdmin4v1.1 (server version) on top of CentOS 6.8

Version1.1

CopyrightCopyright 2013 - 2016, The pgAdmin Development Team

Python Version2.6.6 (r266:84292, Aug 18 2016, 15:13:37) [GCC 4.4.7 20120313 (Red Hat 4.4.7-17)]

Flask Version0.11.1

Application ModeServer

Current Usersystems@surfmerchants.com

Every time I try to SELECT any data from any table I get errors like these (picture attached):

ERROR: column "slug,avail" does not exist LINE 1: ...e(oid,null) as typname FROM pg_type WHERE oid IN (slug,avail... ^

ERROR: column "raw_targets" does not exist LINE 1: ...e(oid,null) as typname FROM pg_type WHERE oid IN (raw_target... ^

From padmin4.log file:

[Tue Jan 10 15:44:13 2017] [error] 2017-01-10 15:44:13,242: ERROR\tpgadmin:\tFailed to execute query (execute_dict) for the server #1- CONN:2246262 (Query-id: 3521662):

[Tue Jan 10 15:44:13 2017] [error] Error Message:ERROR:  column "reloptions" does not exist

[Tue Jan 10 15:44:13 2017] [error] LINE 1: ...e(oid,null) as typname FROM pg_type WHERE oid IN (reloptions…

2017-02-06 06:53:39,574: SQL    pgadmin:    Execute (dict) for server #1 - CONN:4257044 (Query-id: 9753164):

SELECT oid, format_type(oid,null) as typname FROM pg_type WHERE oid IN (slug,available_credits) ORDER BY oid;

2017-02-06 06:53:39,576: ERROR  pgadmin:    Failed to execute query (execute_dict) for the server #1- CONN:4257044 (Query-id: 9753164):

Error Message:ERROR:  column "slug" does not exist

LINE 1: ...e(oid,null) as typname FROM pg_type WHERE oid IN (slug,ava

I have no idea what's going on.

Any help will be appreciated.

Thanks,

Rodrigo Vieira

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support