Re: Why fields are not editable in pgAdmin?

Ah! Nice, makes sense, thanks a lot.

Suggestion: put up a note on the page accessible from the '?' button of the
edit dialog box. It links to:
http://localhost/pgadmin4/help/help/foreign_key_dialog.html
But the page is for 'creation', so I was left wondering why the screenshots
didn't match with what I see.

Hope it helps,
Best,

Michael

Le ven. 24 mai 2019 à 11:24, Dave Page <dpage(at)pgadmin(dot)org> a écrit :

> Hi
>
> On Fri, May 24, 2019 at 10:16 AM Michael Monerau <
> michael(dot)monerau(at)gmail(dot)com> wrote:
>
>> Hello,
>>
>> Although I am logged in as an Administrator user in pgAdmin4, and with a
>> super user role inside my database, the edition fields are always disabled,
>> as in:
>>
>> [image: enter image description here]
>> <https://i.stack.imgur.com/J1Uca.png>
>>
>> So I can't make modifications with the interface.
>>
>> Is there some knob to turn on somewhere to allow that?
>>
> No - they're disabled because PostgreSQL doesn't offer a way to modify
> those options. You have to drop the constraint and add a new one. See
> https://www.postgresql.org/docs/current/sql-altertable.html
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>