On Sep 26, 2008, at 4:19 PM, Tom Lane wrote:
> Decibel! <decibel(at)decibel(dot)org> writes:
>> Does anyone have any ideas on a clean and reliable way to do this?
>
> Use a trigger.
The problem is that the rules are sitting on a view, not a real
table. And the view has columns that don't exist in both tables, so I
can't use a trigger on the tables to deal with everything.
This is 8.1; do later versions have the ability to put triggers on
views?
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828