Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Firing triggers based on certain Insert conditions
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Firing triggers based on certain Insert conditions
- Date: Sun, 28 Jan 2007 13:20:16 -0500
"Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com> writes: > I want this trigger to fire only when after Insert this field 'source' > has value = 'from', otherwise trigger should not be fired at all. > Just wondering if its really possible? No, and it seems pretty silly as a feature request. Why don't you just put the test in the trigger, and have it do nothing when you don't want it to do anything? regards, tom lane
- Follow-Ups:
- Re: Firing triggers based on certain Insert conditions
- From: Harpreet Dhaliwal
- Re: Firing triggers based on certain Insert conditions
- References:
- Firing triggers based on certain Insert conditions
- From: Harpreet Dhaliwal
- Firing triggers based on certain Insert conditions
- Prev by Date: Re: Questions about horizontal partitioning
- Next by Date: Re: Limit on number of users in postgresql?
- Previous by thread: Firing triggers based on certain Insert conditions
- Next by thread: Re: Firing triggers based on certain Insert conditions
- Indexes: