Search code examples
postgresqlpgadminpgadmin-4

Why are some fields not editable in pgAdmin?

Although I am logged in as Administrator user in pgAdmin4, and with an admin role inside my database, the edition fields are always disabled, as in:

enter image description here

So I can't make modifications with the interface.

Is there some knob to turn on somewhere to allow that?

Solution

  • Got a response on the support mailing list, that I post here for reference

    Turns out this is wanted behavior: Postgresql does not offer a way to modify those fields on a constraint (see doc), you have to drop/re-create the constraint. So the UI reflects that.