From: Anibal David Acosta <aa@devshock.com>
To: pgsql-performance@postgresql.org
Subject: does update of column with no relation imply a relation check of other column?
Date: Wed, 19 Oct 2011 12:51:08 -0300
Message-ID: <00ce01cc8e76$ed533480$c7f99d80$@devshock.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: aa@devshock.com
Subject: Re: does update of column with no relation imply a relation check of other column?
In-Reply-To: <00ce01cc8e76$ed533480$c7f99d80$@devshock.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox