Re: Partition insert trigger using C language

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Partition insert trigger using C language
Дата
Msg-id CAJghg4Jn+dBj7uhhjzD2=QiPeVSPcHP6hpS0Np1tY3CvbNRyAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partition insert trigger using C language  (Ali Pouya <alipouya2@gmail.com>)
Ответы Re: Partition insert trigger using C language
Список pgsql-performance

On Mon, Feb 11, 2013 at 1:24 PM, Ali Pouya <alipouya2@gmail.com> wrote:
Hi Matheus,
I try to use your partition_insert_trigger_spi.c code for testing SPI partitionning.
But at execution time the trigdata->tg_trigger->tgargs pointer is null.
Do you know why ?
Thanks a lot
Best Reagrds
Ali Pouya



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

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

Предыдущее
От: Dan Kogan
Дата:
Сообщение: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Следующее
От: Yetkin Öztürk
Дата:
Сообщение: connection poolers' db connections