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

[BUGS] plpgsql error handling bug

2004-09-05 Thread Ivan-Sun1
Hello. 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 control leaves the function exception is occured.