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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
