Thread: [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
Attachment
What's your PostgreSQL version?
--
Regards,
On Mon, Feb 6, 2017 at 7:29 PM, Rodrigo de Lima Vieira <rodrigo.surfmerchants@gmail.com> wrote:
I'm running pgAdmin4v1.1 (server version) on top of CentOS 6.8Version1.1CopyrightCopyright 2013 - 2016, The pgAdmin Development TeamPython 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.1Application ModeServerCurrent Usersystems@surfmerchants.comEvery 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 existLINE 1: ...e(oid,null) as typname FROM pg_type WHERE oid IN (slug,avaI 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