Bjørn T Johansen wrote:
Is there an easier way to create the same trigger for n tables or do I need to run create trigger n times?
You'll need to run CREATE TRIGGER several times I'm afraid. You might be able to wrap this in a function if you'd like though.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match