PostgreSQL 12: column proisagg does not exist
7
votes
1
answer
12398
views
I created a PostGIS database using the following images [here](https://hub.docker.com/r/kartoza/postgis/tags) (i.e. 9.3-2.1, 11.0-2.5 and 12.0 tags), however I'm getting the following errors when I try to open the 'public' schema:


An error has occurred:
11:43:59: Error: ERROR: column "proisagg" does not exist
LINE 9: WHERE proisagg = FALSE AND pronamespace = 2200::oid
HINT: Perhaps you meant to reference the column "pr.prolang".
An error has occurred:
11:46:24: Error: ERROR: column rel.relhasoids does not exist
LINE 1: ...t_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhas...
I found possible solutions [here](https://dba.stackexchange.com/a/238906/181099) and [here](https://sourceforge.net/p/phppgadmin/bugs/469/) . I tried to ask how should I update the query, but I need at least 50 reputation to comment.
Would anyone know how should I fix this question? Or how should I change the definition of the query on pgAdmin?
Thanks in advance.
**System:**
- PostgreSQL 12.0 (Ubuntu 12.0-2.pgdg16.04+1)
- pgAdmin III
- Ubuntu 16.04 LTS
Asked by rmmariano
(175 rep)
Oct 23, 2019, 03:04 PM
Last activity: Oct 23, 2019, 03:33 PM
Last activity: Oct 23, 2019, 03:33 PM