trigger inheritance
От | fcanedo@soneramail.nl |
---|---|
Тема | trigger inheritance |
Дата | |
Msg-id | Pine.LNX.4.21.0107051519040.1165-100000@mars.privatedomain обсуждение исходный текст |
Ответы |
Re: trigger inheritance
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: