Re: Partition insert trigger using C language - Mailing list pgsql-performance

From Ali Pouya
Subject Re: Partition insert trigger using C language
Date
Msg-id CAEEEPmw9wuTFSA0fQCFqvtkEBuW_oqNhM83ZO9NciBkPfO5cqg@mail.gmail.com
Whole thread Raw
In response to Re: Partition insert trigger using C language  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-performance
2013/2/13 Matheus de Oliveira <matioli.matheus@gmail.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.


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 :
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







pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Next
From: Nicolas Charles
Date:
Subject: Re: Surprising no use of indexes - low performance