Re: [GENERAL] C-functions using SPI Missing Magic Block Error

2010-07-02 Thread Saitenheini
I'll try b) and hope I can find a solution. Thanks for your support Joe. Kind Regards, Max. >On 07/02/2010 08:36 AM, saitenhe...@web.de wrote: >> Thanks, I've already tried that. I doesn't make any difference. Still the >> same error. >> >> in Visual C++ I can't even compile it, although I se

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

2010-07-02 Thread Joe Conway
On 07/02/2010 08:36 AM, saitenhe...@web.de wrote: > Thanks, I've already tried that. I doesn't make any difference. Still the > same error. > > in Visual C++ I can't even compile it, although I set all links and > compiler directories like it was told in this post: > http://www.postgresql.org/

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

2010-07-02 Thread Saitenheini
Thanks, I've already tried that. I doesn't make any difference. Still the same error. in Visual C++ I can't even compile it, although I set all links and compiler directories like it was told in this post: http://www.postgresql.org/docs/8.2/interactive/xfunc-c.html I don't have more ideas. Wh

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

2010-07-02 Thread Joe Conway
On 07/02/2010 08:13 AM, saitenhe...@web.de wrote: > Thanks for reply Tom! > > I've tried several version: > > #define _USE_32BIT_TIME_T > > #include "postgres.h" > #include "fmgr.h" > #include "executor\spi.h" > > /* > #ifdef PG_MODULE_MAGIC > PG_MODULE_MAGIC; > #endif > */ > but still the sam

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

2010-07-02 Thread Saitenheini
Thanks for reply Tom! I've tried several version: #define _USE_32BIT_TIME_T #include "postgres.h" #include "fmgr.h" #include "executor\spi.h" /* #ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif */ extern Datum count_person (PG_FUNCTION_ARGS); PG_FUNCTION_INFO_V1(count_person); __declspec(dllex

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

2010-07-02 Thread Tom Lane
saitenhe...@web.de writes: > I compiled the file "pgExampleSPI.c" with the following code without any > error: > /* Use 32-bit timer (provided header file uses 64-bit timer, not > * compatible with Windows postgreSQL versions */ > #define _USE_32BIT_TIME_T > #include "postgres.h" > #include "exe