Hiroshi Inoue wrote:
> Florian G. Pflug wrote:
>
>> I think there should be a big, fat warning that self-referential
>> updates have highly non-obvious behaviour in read-committed mode,
>> and should be avoided.
>
> It seems pretty difficult for PostgreSQL rule system to avoid such
> kind of updates. I'm suspicious if UPDATABLE VIEWS can be implemented
> using the rule system.
Remember this affects all self-referential joins on an UPDATE (and
DELETE?) not just views. It's just that a rule is more likely to produce
that type of query.
--
Richard Huxton
Archonet Ltd