Re: Partitionning by trigger - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Partitionning by trigger
Date
Msg-id A737B7A37273E048B164557ADEF4A58B057B8939@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Partitionning by trigger  (Ali Pouya <alipouya2@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ali Pouya
Date:
Subject: Partitionning by trigger
Next
From: Dave Cramer
Date:
Subject: Re: JDBC not returning update count from updateable view