Re: Partitioned tables and triggers

From: mephysto <mephystoonhell(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Partitioned tables and triggers
Date: 2012-04-06 08:06:12
Message-ID: 1333699572327-5622304.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Andreas Kretschmer-2 wrote
>
> Depends. Is this a insert-only - table, or do you have updates/deletes?
>

No, certainly I need UPDATE, and probably DELETE also. Do I need to create
UPDATE and DELETE trigger?

Andreas Kretschmer-2 wrote
>
> Your INSERT-Function should return NULL to avoid insert into the
> main-table.
>
I understood, thank you very much.

Bye.

Mephysto

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Partitioned-tables-and-triggers-tp5622192p5622304.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2012-04-07 02:29:05 my float function returns NaN
Previous Message Andreas Kretschmer 2012-04-06 07:48:07 Re: Partitioned tables and triggers