pgAdmin4 - Fetching Type Error

From: Rodrigo de Lima Vieira <rodrigo(dot)surfmerchants(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin4 - Fetching Type Error
Date: 2017-02-06 13:59:44
Message-ID: CAEVStnMkS3_ceOzK+NgZ5te25CbqRS+R4arCpR_gBsrJ-fNc6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)surfmerchants(dot)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 Content-Type Size
image/png 14.2 KB

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Murtuza Zabuawala 2017-02-06 14:08:46 Re: pgAdmin4 - Fetching Type Error
Previous Message A.J.L.R. Hasekamp 2017-02-05 16:22:25 pgAdmin4 and Archlinux