Fwd: [GENERAL] Before triggers and usage in partitioned tables

2010-03-23 Thread Sergio Ramazzina
Sorry but I mistakenly replied only to Albe. Repost it to the list. Apologize me but also the server version is not correct is 8.1.11 (I forget the last 1). Regards S -- Forwarded message -- From: Sergio Ramazzina Date: 2010/3/23 Subject: Re: [GENERAL] Before triggers and usage

Re: [GENERAL] Before triggers and usage in partitioned tables

2010-03-23 Thread Sergio Ramazzina
W.*); ELSIF ( NEW.data >= DATE '2010-01-28' AND NEW.data < DATE '2010-01-29' ) THEN INSERT INTO tp_wind_dcn_day28 VALUES (NEW.*); ELSIF ( NEW.data >= DATE '2010-01-29' AND NEW.data < DATE '2010-01-30' ) THEN INSERT INTO tp

[GENERAL] Before triggers and usage in partitioned tables

2010-03-23 Thread Sergio Ramazzina
Hi everybody, I'm new to postgresql and I need some help to understand the behaviour of before insert triggers in postgresql. I'm trying the sample documented in the user manual about implementing table partitions ( http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html) and I've a p