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

From Matheus de Oliveira
Subject Re: Partition insert trigger using C language
Date
Msg-id CAJghg4Jn+dBj7uhhjzD2=QiPeVSPcHP6hpS0Np1tY3CvbNRyAg@mail.gmail.com
Whole thread Raw
In response to Re: Partition insert trigger using C language  (Ali Pouya <alipouya2@gmail.com>)
Responses Re: Partition insert trigger using C language
List 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 by date:

Previous
From: Dan Kogan
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Next
From: Yetkin Öztürk
Date:
Subject: connection poolers' db connections