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
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
