Oliver Duke-Williams <[EMAIL PROTECTED]> writes:
> So far so good, but what I'd like to do is to be able to change a value
> of a, and have this cascaded to b; however this gives an integrity
> violation error:
>> update foo set a = 5 where a = 2;
> ERROR: chk_a referential integrity violation - key referenced from foo
> not found in foo
Seems to work in 7.3.4 and CVS tip:
regression=# update foo set a = 5 where a = 2;
UPDATE 1
regression=# select * from foo;
a | b
---+---
1 | 1
3 | 5
5 | 5
(3 rows)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
