Re: [GENERAL] Hidden Risk w/ UPDATE Cascade and Trigger-Based Validation

2011-06-03 Thread Tom Lane
"David Johnston" writes: > I am trying to get a better understanding of how the following Foreign Keys > with Update Cascades and validation trigger interact. The basic setup is a > permission table where the two permission parts share a common > "group/parent" which is embedded into their id/PK

Re: [GENERAL] Hidden Risk w/ UPDATE Cascade and Trigger-Based Validation

2011-06-03 Thread Dean Rasheed
On 3 June 2011 01:26, David Johnston wrote: > Hi, > > > > I am trying to get a better understanding of how the following Foreign Keys > with Update Cascades and validation trigger interact.  The basic setup is a > permission table where the two permission parts share a common > “group/parent” whic

[GENERAL] Hidden Risk w/ UPDATE Cascade and Trigger-Based Validation

2011-06-02 Thread David Johnston
Hi, I am trying to get a better understanding of how the following Foreign Keys with Update Cascades and validation trigger interact. The basic setup is a permission table where the two permission parts share a common "group/parent" which is embedded into their id/PK and which change via the F