does update of column with no relation imply a relation check of other column?

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: does update of column with no relation imply a relation check of other column?
Date: 2011-10-19 15:51:08
Message-ID: 00ce01cc8e76$ed533480$c7f99d80$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

For example:

Table A

-id (PK)

-name

Table B

-table_a_id (PK, FK)

-address

When I do an insert on table B, the database check if value for column
"table_a_id" exists in table A

But, if I do an update of column "address" of table B, does the database
check again?

My question is due to the nature of and update in postgres, that basically
is a new version "insert".

Thanks

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Jaskiewicz 2011-10-19 16:42:59 Re: does update of column with no relation imply a relation check of other column?
Previous Message Scott Marlowe 2011-10-19 15:44:39 Re: How many Cluster database on a single server