Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioning: avoid insert in master table - Mailing list pgsql-novice

From Chetan Suttraway
Subject Re: Partitioning: avoid insert in master table
Date
Msg-id CAPtHcnEB+Amzzq79SHQh3ec84j4nX7-pbiZ2sx=EvvKTvnWkxA@mail.gmail.com
Whole thread Raw
In response to Partitioning: avoid insert in master table  (Sergio Sinuco <sergiosinuco@datatraffic.com.co>)
List pgsql-novice
Tree view


On Wed, Jan 4, 2012 at 5:00 AM, Sergio Sinuco <sergiosinuco@datatraffic.com.co> wrote:
Hi everyone. I have problems with the trigger in master table in a  basic table partitioning. The trigger is "ON BEFORE INSERT" and return NULL, but the row is inserted in the master and child table. I'm using Postgresql 8.4. What can I do?


Could you please share a simple test case to understand the query?

Regards,
Chetan

--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

EnterpriseDB Blog : http://blogs.enterprisedb.com




pgsql-novice by date:

Previous
From: Chetan Suttraway
Date:
Subject: Re: Duplicate information in parent and child tables
Next
From: "lmanorders"
Date:
Subject: Using libpq 8.4 with Postgre 9.1