Re: Partitioned tables and triggers - Mailing list pgsql-novice

From mephysto
Subject Re: Partitioned tables and triggers
Date
Msg-id 1333699572327-5622304.post@n5.nabble.com
Whole thread Raw
In response to Re: Partitioned tables and triggers  (Andreas Kretschmer <akretschmer@spamfence.net>)
List 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.

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Partitioned tables and triggers
Next
From: Frank Bax
Date:
Subject: my float function returns NaN