Re: [HACKERS] Problem with FK referential actions

2001-08-01 Thread Stephan Szabo
On Wed, 1 Aug 2001, Jan Wieck wrote: > Stephan Szabo wrote: > > The output from the select, should I believe be (3,1), (4,1) > > not (4,1), (4,1). I think we're violating General Rule 4 (I think > > that's it) on the referential constraint definition ("For every > > row of the referenced table,

Re: [HACKERS] Problem with FK referential actions

2001-08-01 Thread Jan Wieck
Stephan Szabo wrote: > The output from the select, should I believe be (3,1), (4,1) > not (4,1), (4,1). I think we're violating General Rule 4 (I think > that's it) on the referential constraint definition ("For every > row of the referenced table, its matching rows, unique matching > rows, and n