PostgreSQL: column "rolcatupdate" does not exist error?

postgresql psql navicat
igorb0214 picture igorb0214 · Aug 17, 2016 · Viewed 10.8k times · Source

I installed PostgreSQL on new server.

When I try create new table or new data base, get this error:

column "rolcatupdate" does not exist.

How can I fix it?

Answer

Kristo Mägi picture Kristo Mägi · Aug 17, 2016

What client/framework are you using for creating a table?

In Postgres 9.5 "rolcatupdate" is not anymore supported (list of pg_roles: https://www.postgresql.org/docs/current/static/view-pg-roles.html)

It might be that some client(s)/framework(s) still use it.

From the ChangeLog:

Remove the pg_authid catalog's rolcatupdate field, as it had no usefulness (Adam Brightwell)

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More