Re: pgAdmin4 - Fetching Type Error

What's your PostgreSQL version?

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Feb 6, 2017 at 7:29 PM, Rodrigo de Lima Vieira <
rodrigo(dot)surfmerchants(at)gmail(dot)com> wrote:

> 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
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>