From: Tom Lane <tgl@sss.pgh.pa.us>
> "Robert Creager" <pgsql-bugs@logicalchaos.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
Yes, and yes. Any work arounds (ie current sources, smarter SQL),
other than to break this up into multiple updates?
Thanks,
Rob