Re: Partitioning: avoid insert in master table

From: Chetan Suttraway <chetan(dot)suttraway(at)enterprisedb(dot)com>
To: Sergio Sinuco <sergiosinuco(at)datatraffic(dot)com(dot)co>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Partitioning: avoid insert in master table
Date: 2012-02-13 13:12:16
Message-ID: CAPtHcnEB+Amzzq79SHQh3ec84j4nX7-pbiZ2sx=EvvKTvnWkxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Jan 4, 2012 at 5:00 AM, Sergio Sinuco <
sergiosinuco(at)datatraffic(dot)com(dot)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

Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message lmanorders 2012-02-13 19:39:57 Using libpq 8.4 with Postgre 9.1
Previous Message Chetan Suttraway 2012-02-13 13:08:29 Re: Duplicate information in parent and child tables