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