Re: Partitionning by trigger

Ali Pouya wrote:
> I sent the following mail yesterday but I do not see it in the list.
> So I retry

It is there all right:
http://www.postgresql.org/message-id/CAEEEPmwq_3=hGEC69-2EkCWTiwq0dme==8SoU29E9k2DCCgUEw@mail.gmail.com

> 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 don't think that is possible.

Yours,
Laurenz Albe