Re: Partition insert trigger using C language

Поиск
Список
Период
Сортировка
От Ali Pouya
Тема Re: Partition insert trigger using C language
Дата
Msg-id CAEEEPmw9wuTFSA0fQCFqvtkEBuW_oqNhM83ZO9NciBkPfO5cqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partition insert trigger using C language  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Следующее
От: Nicolas Charles
Дата:
Сообщение: Re: Surprising no use of indexes - low performance