Partitionning by trigger

From: Ali Pouya <alipouya2(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Partitionning by trigger
Date: 2013-02-25 12:44:47
Message-ID: CAEEEPmwq_3=hGEC69-2EkCWTiwq0dme==8SoU29E9k2DCCgUEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have created a partitionned table and a Pl/PgSQL trigger exactly as
explained here<http://www.postgresql.org/docs/9.2/static/ddl-partitioning.html>in
the documentation.

It works fine but the INSERT and COPY commands return zero instead of the
number of the rows actually inserted. Worse : the RETURNING clause returns
NULL when inserting through the trigger.

I encounter the same problem with a C language trigger function.

Is there anyway to obtain a behavior similar to that of the direct
insertion ?

I use PostgreSQL 9.2.3 in Linux Fedora 2.6 environment.
I can send a simplified self contained test case if required.

Thanks for your answer

Best Regards
Ali Pouya

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Duffey 2013-02-25 13:01:30 Re: Floating point error
Previous Message Stefan Andreatta 2013-02-25 11:07:19 Re: autoanalyze criteria