Re: Do we need a TODO? (was Re: Concurrently updating an updatable view)

Added to TODO:

* Fix self-referential UPDATEs seeing inconsistent row versions in read-committed mode
 http://archives.postgresql.org/pgsql-hackers/2007-05/msg00507.php


---------------------------------------------------------------------------

Richard Huxton wrote:
> Florian G. Pflug wrote:
> > 
> > Is there consensus what the correct behaviour should be for
> > self-referential updates in read-committed mode? Does the SQL Spec
> > have anything to say about this?
> 
> This seems to have gone all quiet. Do we need a TODO to keep a note of 
> it? Just "correct behaviour for self-referential updates"
> 
> Hiroshi originally noted the problem in one of his views here:
>    http://archives.postgresql.org/pgsql-hackers/2007-05/msg00507.php
> 
> -- 
>    Richard Huxton
>    Archonet Ltd
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +