heap-only tuples, and constraints

From: "maxxedit(at)gmail(dot)com" <maxxedit(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: heap-only tuples, and constraints
Date: 2010-08-14 07:29:47
Message-ID: AANLkTi=z1TR9ht6Z_sZevjifVShyA5QTrW7_aW_KSNty@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-08-14 07:42:08 Re: Windows 2003 server installation issue
Previous Message Vikram Patil 2010-08-14 06:49:44 Windows 2003 server installation issue