Re: C-functions using SPI Missing Magic Block Error

Saitenheini@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 "executor\spi.h"

> #ifdef PG_MODULE_MAGIC
> PG_MODULE_MAGIC;
> #endif

That's not going to do anything because you didn't #include the header
that defines PG_MODULE_MAGIC.  I think it's fmgr.h but not sure offhand.
I'd suggest taking out the #ifdef so you actually get an error if the
definition isn't provided.

            regards, tom lane