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=3DhGEC69-2EkCWTiwq0dme=3D=
=3D8SoU29E9k2DCCgUEw@mail.gmail.com

> I have created a partitionned table and a Pl/PgSQL trigger exactly as exp=
lained here
> <http://www.postgresql.org/docs/9.2/static/ddl-partitioning.html>  in the=
 documentation.
>=20
> 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 throug=
h the trigger.
>=20
> I encounter the same problem with a C language trigger function.
>=20
> Is there anyway to obtain a behavior similar to that of the direct insert=
ion ?

I don't think that is possible.

Yours,
Laurenz Albe