Re: Trigger triggered from a foreign key

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trigger triggered from a foreign key
Date: 2012-10-22 11:29:34
Message-ID: k63amu$lif$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2012-10-19, Victor Sterpu <victor(at)caido(dot)ro> wrote:
> I have this trigger that works fine. The trigger prevents the deletion
> of the last record.
> But I want skip this trigger execution when the delete is done from a
> external key.
> How can I do this?

perhaps you have to use a rule instead of a trigger?

--
⚂⚃ 100% natural

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2012-10-26 09:02:01 pull in most recent record in a view
Previous Message Brice André 2012-10-21 19:18:14 Partition database between users and implement disk quotas