"Robert Creager" <pgsql-bugs(at)logicalchaos(dot)org> writes:
> I found reference to this problem at
> http://archives.postgresql.org/pgsql-general/2003-02/msg00135.php,
> but there was no apparent resolution.
If (a) obs_v_trigger is a BEFORE trigger, *and* (b) the problem UPDATE
could try to update a row of obs_v more than once (ie, there are
multiple rows in obs_i/files that match a row in obs_v), then I think
this is a known problem. Otherwise, we need to dig more ...
regards, tom lane