Re: [SQL] Re: Order of evaluation in triggers for checks on inherited table partitions

2011-05-31 Thread Kevin Crain
Okay, I figured out what is going on. Even though I was running the update on the master table the trigger was not being applied because it was actually being ran using the child table where the record to be updated resided. So the trigger function was being skipped and it was running as an ordin

Re: [SQL] Re: Order of evaluation in triggers for checks on inherited table partitions

2011-05-31 Thread Kevin Crain
Can procedural languages be used in rules? I didn't see any examples in the documentation that suggested something like this could be done using rules. --Kevin Crain On Mon, May 30, 2011 at 2:21 AM, Jasen Betts wrote: > On 2011-05-27, Kevin Crain wrote: >> I am trying to create a trigger on up

[SQL] Re: Order of evaluation in triggers for checks on inherited table partitions

2011-05-30 Thread Jasen Betts
On 2011-05-27, Kevin Crain wrote: > I am trying to create a trigger on updates to a table that is > partitioned. The child tables are partitioned by month and include > checks on a timestamp field. > However when I try to update an existing record with a > timestamp that would place it in a chi