| From: | Ali Pouya <alipouya2(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Partitionning by trigger |
| Date: | 2013-02-25 12:44:47 |
| Message-ID: | CAEEEPmwq_3=hGEC69-2EkCWTiwq0dme==8SoU29E9k2DCCgUEw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Duffey | 2013-02-25 13:01:30 | Re: Floating point error |
| Previous Message | Stefan Andreatta | 2013-02-25 11:07:19 | Re: autoanalyze criteria |