Re: Can a table have a reference to itself?

Oliver Duke-Williams <o(dot)duke-williams(at)geog(dot)leeds(dot)ac(dot)uk> 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