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