Partitioned tables and triggers
От | mephysto |
---|---|
Тема | Partitioned tables and triggers |
Дата | |
Msg-id | 1333695380592-5622192.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: Partitioned tables and triggers
Re: Partitioned tables and triggers |
Список | pgsql-novice |
Hello to everyone, yesterday I created my first montly partitioned table with its insert trigger following the specific manual page. At the moment table seems to work correctly, but I have some doubts: 1 - After an insert operation, I can see data either in master and in child table. Is this a normal behavior? 2 - I created only insert trigger, but not update and delete. Do I need also these triggers to managing data correctly? 3 - When a BEFORE INSERT trigger function execute in its turn an INSERT operation, are the origina INSERT executed or not? Are the data inserted in master table also, and not only in child table? Thanks in advance. Mephysto -- View this message in context: http://postgresql.1045698.n5.nabble.com/Partitioned-tables-and-triggers-tp5622192p5622192.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
В списке pgsql-novice по дате отправления: