Hi,
I'm new to PostgreSQL and am currently trying to figure out the
object-oriented stuff.
When I make a new table (B) that inherits from another table (A), I would
expect that B inherits the triggers (among other things) from A. It does
not! In the reference manual (CREATE TABLE) it says "Postgres
automatically allows the created table to inherit functions on tables
above it in the inheritance hierarchy."
Since functions don't belong to tables (correct me if I'm wrong) I would
believe triggers are ment here!
So my question is:
Is 'trigger inheritance' available and functional in PostgreSQL 7.1?
If so, how do I turn this on?
If not, is this being worked on (according to the todo, *not*)? Do I need
to take this to the hackers/development list?
For those who are curious:
I solved my problem by manually adding a
trigger for B, that calls the same function that the trigger for A
calls. If necessary I add a new trigger for B (with specific
functionality for B) after adding the "inherited" trigger.
But this is extra work and administration with all it's extra problems.
TIA,
Francisco