Re: [SQL] Transactional behaviour with trigger

2006-09-17 Thread Joost Kraaijeveld
Hi Michael, Thanks for answering. On Sun, 2006-09-17 at 08:36 -0600, Michael Fuhr wrote: > On Sun, Sep 17, 2006 at 02:32:10PM +0200, Joost Kraaijeveld wrote: > Where does prototype.customers fit in? Are you sure it has a row > that matches the WHERE clause? Where would that row have come from?

Re: [SQL] Transactional behaviour with trigger

2006-09-17 Thread Michael Fuhr
On Sun, Sep 17, 2006 at 02:32:10PM +0200, Joost Kraaijeveld wrote: > For the contactaddress I also have a trigger(function) that should > update the record in the third table with the additional info of the > contactaddress: > > > SELECT INTO customer_record objectid FROM prototype.customers