Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgreSQL: column "rolcatupdate" does not exist error?

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?

like image 467
igorb0214 Avatar asked Jul 12 '26 11:07

igorb0214


1 Answers

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)

like image 187
Kristo Mägi Avatar answered Jul 15 '26 12:07

Kristo Mägi



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!