heap-only tuples, and constraints

Поиск
Список
Период
Сортировка
От maxxedit@gmail.com
Тема heap-only tuples, and constraints
Дата
Msg-id AANLkTi=z1TR9ht6Z_sZevjifVShyA5QTrW7_aW_KSNty@mail.gmail.com
обсуждение исходный текст
Ответы Re: heap-only tuples, and constraints  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-general
Hi,

Question about heap-only tuples, and constraint checking.

Does this statement (UPDATE user SET email='newChangedVal',
password='existingVal') requires updating an index on user.password?
Or more generally, if an UPDATE includes an explicit but unchanged
value for an index column, does postgres need to also update the index
entries? Or does HOT apply only when indexed column is missing or not
explicit (i.e. password=password)?

Along the same line of thought as above, if password is a foreign key
column and if an UPDATE includes an explicit but unchanged value for
this fk column, does postgres need to check constraint satisfiability?

Thanks

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

Предыдущее
От: Chris Berry
Дата:
Сообщение: Delete Trigger
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Delete Trigger