Sample Header Ad - 728x90

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: enter image description here enter image description here
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