[GENERAL] Foreign key verification trigger conditions

2009-05-31 Thread j-lists
I have an update statement that affects every row in a given table. For that table it changes the value in a single column, which itself has a foreign key constraint. The table has an additional 9 foreign keys, some of which reference large tables. My expectation would be that only the changed colu

Re: [GENERAL] Foreign key verification trigger conditions

2009-06-01 Thread j-lists
, 2009 at 9:20 AM, Tom Lane wrote: > j-lists writes: >> I have an update statement that affects every row in a given table. >> For that table it changes the value in a single column, which itself >> has a foreign key constraint. The table has an additional 9 foreign &