pgAdmin4 Query Error "not enough values to unpack (expected 5, got 4)"

I can't run queries on pgAdmin4 on Ubuntu 19.04. I can view data through pgAdmin and execute queries through my terminal. However, whenever I try to use the query tool I get the error not enough values to unpack (expected 5, got 4).

I've tried reinstalling pgAdmin and psycopg2. Following this guide

3 answers

  • answered 2019-08-13 03:23 binbeing

    Just like the error said, your query is wrong :not enough values to unpack (expected 5, got 4).

    have you ever lost a parameter?

  • answered 2019-08-13 11:09 user1936789

    I had the same problem on Debian Buster. I had psycopg2 installed through pip3 to solve the older problem with no returns in pgadmin on Debian.

    So now i went to pgadmin config (right mouse button to pgadmin icon in tray) and deleted the custom path to python libraries. After that it works great.

  • answered 2019-08-13 17:37 Mark Faulkner

    I'm on Ubuntu 18.04, running pgAdmin4 4.11 in Desktop mode. As user1936789 suggested, clearing the Python Path on the Python tab of the PgAdmin 4 Configuration screen cleared up the problem for me.