Re: explicit-locking.html "key values" reference

Поиск
Список
Период
Сортировка
Искать
От
David G. Johnston
Тема
Re: explicit-locking.html "key values" reference
Дата
в 03:20:31
Msg-id
CAKFQuwbEFuHrg0QvmPBOM-BpewVVnNomx8DVqZWLdgF+Auc5hg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
explicit-locking.html "key values" reference jian he <jian.universality@gmail.com>
Re: explicit-locking.html "key values" reference "David G. Johnston" <david.g.johnston@gmail.com>
On Fri, May 26, 2023 at 8:02 PM jian he <jian.universality@gmail.com> wrote:

I still feel confused about "the key values". 

The "key" here is the Foreign Key relationship.  In short, FOR NO KEY UPDATE, promises that PK/FK values on the table will not be changed.  Only non-FK/PK columns can be changed.  In neither case may the row be removed either since that would necessitate changing the key to "non-existent".  However, the "UPDATE" part basically means "I am going to update some other column".  On the KEY SHARE side you basically get "I only care that this row/relationship continues to exist, you may change other attributes".

David J.


В списке pgsql-general по дате отправления
От: jian he
Дата:
От: 文一
Дата:
FAQ