Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 20D2BB5DBFC for ; Wed, 19 Oct 2011 12:51:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 76902-01 for ; Wed, 19 Oct 2011 15:51:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-yx0-f174.google.com (mail-yx0-f174.google.com [209.85.213.174]) by mail.postgresql.org (Postfix) with ESMTP id 6688FB5DBCE for ; Wed, 19 Oct 2011 12:51:13 -0300 (ADT) Received: by yxp4 with SMTP id 4so1821672yxp.19 for ; Wed, 19 Oct 2011 08:51:12 -0700 (PDT) Received: by 10.150.212.15 with SMTP id k15mr6856240ybg.56.1319039472600; Wed, 19 Oct 2011 08:51:12 -0700 (PDT) Received: from AnibalVAIO ([200.85.32.68]) by mx.google.com with ESMTPS id z6sm16874742anf.22.2011.10.19.08.51.09 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 19 Oct 2011 08:51:11 -0700 (PDT) From: "Anibal David Acosta" To: 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CF_01CC8E5D.C8070DF0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcyOdo04kHTn0ZXDRJi34uTobZ2DLA== Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201110/165 X-Sequence-Number: 45387 This is a multipart message in MIME format. ------=_NextPart_000_00CF_01CC8E5D.C8070DF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_00CF_01CC8E5D.C8070DF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_00CF_01CC8E5D.C8070DF0--