Re: Why fields are not editable in pgAdmin?

Поиск
Список
Период
Сортировка
От Michael Monerau
Тема Re: Why fields are not editable in pgAdmin?
Дата
Msg-id CAOpvgNcsVeBjSH86mda7J7bHM0ZBqE+CMovJN9MpF8wZZb-_pA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why fields are not editable in pgAdmin?  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
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@pgadmin.org> a écrit :
Hi

On Fri, May 24, 2019 at 10:16 AM Michael Monerau <michael.monerau@gmail.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:

enter image description here

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

В списке pgadmin-support по дате отправления:

Предыдущее
От: Michael Monerau
Дата:
Сообщение: Re: Install pgadmin4 on Fedora 30
Следующее
От: shaurya jain
Дата:
Сообщение: PG_ADMIN:- Working too slow