Oleg Mayevskiy <oleg(dot)mayevskiy(at)s2002(dot)tu-chemnitz(dot)de> writes:
> it seems to be a simple problem, but it is not.
Yes it is ... you're expecting the RI triggers to fire during the
plpgsql function, but in fact they fire at completion of the outer
statement that called the plpgsql function.
There's been some debate about whether this is really the most
desirable behavior, but that's how it is at the moment.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: email lists||Date: 2004-06-01 12:29:04|
|Subject: assistance on self join pls|
|Previous:||From: Jaime Casanova||Date: 2004-05-31 14:19:49|
|Subject: joining a table with a function|