Partitioned tables and triggers

From: mephysto <mephystoonhell(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Partitioned tables and triggers
Date: 2012-04-06 06:56:20
Message-ID: 1333695380592-5622192.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2012-04-06 07:48:07 Re: Partitioned tables and triggers
Previous Message Coby Beck 2012-04-05 04:46:19 Re: Function returning SETOF returns nothing