Re: [BUGS] plpgsql error handling bug

2004-09-05 Thread Gaetano Mendola
Tom Lane wrote: > [EMAIL PROTECTED] writes: > >>I found a bug in the behaviour of plpgsql error handling system >>while trying to handle foreign key violation exception. > > > This is not a bug in the exception system. > > The problem is that FK constraints are enforced by triggers that do not > fi

Re: [BUGS] plpgsql error handling bug

2004-09-05 Thread Tom Lane
[EMAIL PROTECTED] writes: > I found a bug in the behaviour of plpgsql error handling system > while trying to handle foreign key violation exception. This is not a bug in the exception system. The problem is that FK constraints are enforced by triggers that do not fire until the end of the outer

Re: [BUGS] plpgsql error handling bug

2004-09-05 Thread Stephan Szabo
On Sun, 5 Sep 2004 [EMAIL PROTECTED] wrote: > I found a bug in the behaviour of plpgsql error handling system > while trying to handle foreign key violation exception. > > When this error occured, control doesn't jump to exception handling block. > It moves to the next statement instead. When con