Re: Partitionning by trigger

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Partitionning by trigger
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B057B8939@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Partitionning by trigger  (Ali Pouya <alipouya2@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ali Pouya
Дата:
Сообщение: Partitionning by trigger
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: JDBC not returning update count from updateable view