Re: [SQL] Update aborted if trigger function fails?

2005-04-12 Thread Carlos Moreno
Andrew Sullivan wrote: On Tue, Apr 12, 2005 at 10:55:30AM -0400, Carlos Moreno wrote: I guess the concern came up as result of a particular situation, in which failing to properly process the trigger function is not that crucial (I wanted to update some additional information that is "optional", an

Re: [SQL] Update aborted if trigger function fails?

2005-04-12 Thread Andrew Sullivan
On Tue, Apr 12, 2005 at 10:55:30AM -0400, Carlos Moreno wrote: > > I guess the concern came up as result of a particular > situation, in which failing to properly process the > trigger function is not that crucial (I wanted to > update some additional information that is "optional", > and that can

Re: [SQL] Update aborted if trigger function fails?

2005-04-12 Thread Carlos Moreno
Richard Huxton wrote: I just noticed this (odd?) behaviour, and it kind of scares me. Isn't this a little fragile? Is there something I could do to avoid this situation? Should trigger functions be extremely simple as to guarantee that an error would never happen? There's nothing else it can do,

Re: [SQL] Update aborted if trigger function fails?

2005-04-12 Thread Richard Huxton
Carlos Moreno wrote: Hi, I just noticed this (odd?) behaviour, and it kind of scares me. Isn't this a little fragile? Is there something I could do to avoid this situation? Should trigger functions be extremely simple as to guarantee that an error would never happen? There's nothing else it can

[SQL] Update aborted if trigger function fails?

2005-04-11 Thread Carlos Moreno
Hi, I just noticed this (odd?) behaviour, and it kind of scares me. For testing purposes, I put a deliberate syntax error; this wouldn't happen in a real-life situation. But what if the error gets triggered by something that happens later on? say, if the trigger function uses a field that later o