3

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?

Mike Zavarello
  • 3,514
  • 4
  • 29
  • 43
igorb0214
  • 67
  • 2
  • 2
  • 9

1 Answers1

3

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)

guettli
  • 25,042
  • 81
  • 346
  • 663
Kristo Mägi
  • 1,584
  • 12
  • 15