Thanks for the response. I'm working on a simplified example now. It will take a little time to set it up. I will post all the code for creating the much simplified tables and trigger. Again, thanks for the response... On Tuesday 21 March 2006 08:15 am, Martijn van Oosterhout saith: > On Tue, Mar 21, 2006 at 06:56:23AM -0500, Terry Lee Tucker wrote: > > Hello List: > > > > I posted a question over the weekend regarding this issue but I failed to > > communicate effectively what the problem is. I was weary :o[ Let me try > > again. > > I think one of the reasons why you're not getting any responses is that > the problem is complicated but you have not provided a complete > example. You don't for example say how the trigger is defined > (BEFORE|AFTER) (ROW|STATEMENT) DEFERRED yes/no? If you really want an > answer you're going to need to provide a complete example people can > run on their own systems. > > have a nice day, -- Quote: 39 "Posterity -- you will never know how much it has cost my generation to preserve your freedom. I hope you will make good use of it." --John Quincy Adams Work: 1-336-372-6812 Cell: 1-336-363-4719 email: terry@xxxxxxxx