Re: [GENERAL] heap-only tuples, and constraints

On Sat, 2010-08-14 at 00:29 -0700, maxxe...@gmail.com wrote: > 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 po

[GENERAL] heap-only tuples, and constraints

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 postgre