Re: Partition insert trigger using C language

[Matheus de Oliveira <matioli.matheus@xxxxxxxxx>]

On Mon, Feb 11, 2013 at 1:24 PM, Ali Pouya <alipouya2@xxxxxxxxx> 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.

[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