Partitionning by trigger

Поиск
Список
Период
Сортировка
От Ali Pouya
Тема Partitionning by trigger
Дата
Msg-id CAEEEPmyb+YViieqDiT2Rg5GcwHOT=Tx8nXS47oitBfGmCMwkWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Partitionning by trigger  (Ali Pouya <alipouya2@gmail.com>)
Ответы Re: Partitionning by trigger  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Hi all,
I sent the following mail yesterday but I do not see it in the list.
So I retry
==============

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Floating point error
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Partitionning by trigger