Re: NEW in Rule makes another nextval call?

Sven Willenberger wrote:
>  Is this intended behavior? or is the NEW
> acting as a macro that is replace by "nextval()" ?

Well, it's understood behaviour even if not quite "intended".

You are quite right, rules basically act like macros with all the 
limitations they have. What is actually happening behind the scenes is 
that the query is being rewritten to alter the query-plan tree. You 
should be able to get your rule to work by referring to 
currval() rather than NEW.custid.

However, in this particular case I think you want an after insert 
trigger on customer rather than a rule.

-- 
   Richard Huxton
   Archonet Ltd