Re: [PERFORM] Partition insert trigger using C language

2013-02-15 Thread Ali Pouya
2013/2/13 Matheus de Oliveira > > 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 partitio

Re: [PERFORM] Partition insert trigger using C language

2013-02-11 Thread Ali Pouya
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 2013/1/11 Matheus de Oliveira > > On Fri, Jan 11, 201

Re: [PERFORM] Performance on Bulk Insert to Partitioned Table

2013-01-17 Thread Ali Pouya
Ali, > You can save the source as partition.c and use: > > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute > -Wformat-security -fno-strict-aliasing -fwrapv -fpic -DREFINT_VERBOSE -I. > -I. -I"/usr/pgsql-9.2/include/server

Re: [PERFORM] Performance on Bulk Insert to Partitioned Table

2013-01-17 Thread Ali Pouya
2012/12/27 Charles Gomes > So far that's what I got http://www.widesol.com/~charles/pgsql/partition.c > I had some issues as He uses HeapTuples and on 9.2 I see a Slot. > Hi Charles, I copied your C code partition.c and am trying to test it. For compiling you suggest : ... gcc -I "./" -fpic -c