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

Reply via email to