From: | Ali Pouya <alipouya2(at)gmail(dot)com> |
---|---|
To: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, Charles Gomes <charlesrg(at)outlook(dot)com> |
Subject: | Re: Partition insert trigger using C language |
Date: | 2013-02-15 08:47:20 |
Message-ID: | CAEEEPmw9wuTFSA0fQCFqvtkEBuW_oqNhM83ZO9NciBkPfO5cqg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
2013/2/13 Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
>
> Hi Ali,
>
> That is probably because you did not passed a parameter when defined the
> trigger. You can follow the model at [1]. When creating the trigger, you
> have to use a string parameter with the name of the field with the date
> value used for the partition.
>
> Let me know if you find any other problem.
>
> [1]
> https://github.com/matheusoliveira/pg_partitioning_tests/blob/master/test/spi/schema.sql
>
> Regards,
> --
> Matheus de Oliveira
> Analista de Banco de Dados
> Dextra Sistemas - MPS.Br nível F!
> www.dextra.com.br/postgres
>
Hi Matheus,
Yes. You are right. Now it's OK.
I thought that the trigger function cannont vehicle any arguments. I had
mis-interpreted this phrase of the
Documentation<http://www.postgresql.org/docs/9.2/static/sql-createtrigger.html>:
*function_name** *
*A user-supplied function that is declared as taking no arguments and
returning type trigger, which is executed when the trigger fires.*
Thanks and best regards
Ali
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Charles | 2013-02-15 09:00:24 | Re: Surprising no use of indexes - low performance |
Previous Message | Scott Marlowe | 2013-02-15 04:47:45 | Re: High CPU usage / load average after upgrading to Ubuntu 12.04 |