Re: Trouble with NEW

From: "David Johnston" <polobo(at)yahoo(dot)com>
To: "'Adrian Klaver'" <adrian(dot)klaver(at)gmail(dot)com>, "'Bob Pawley'" <rjpawley(at)shaw(dot)ca>
Cc: "'Alan Hodgson'" <ahodgson(at)simkin(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trouble with NEW
Date: 2012-07-19 18:26:39
Message-ID: 00b001cd65dc$0a891960$1f9b4c20$@yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> 4) If you want to pull information from another table, you either need to set
> up a FOREIGN KEY relationship that you can leverage or you need to do a
> query in the trigger function that pulls in the necessary information.
>

I do not get where the "OR" comes from. There is nothing magical about FOREIGN KEY that causes NEW magically contain additional values. Foreign Key or not you still have to "...do a query in the trigger function...".

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-07-19 19:13:00 Re: Trouble with NEW
Previous Message Adrian Klaver 2012-07-19 17:26:07 Re: Trouble with NEW