Re: explicit-locking.html "key values" reference
От
David G. Johnston
Тема
Re: explicit-locking.html "key values" reference
Дата
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 по дате отправления