Re: C-Functions using SPI - Missing Magic Block

On Sat, Jul 03, 2010 at 09:35:56AM +0800, Craig Ringer wrote:
> On 02/07/10 21:26, Saitenheini@web.de wrote:
>
> > #ifdef PG_MODULE_MAGIC
> > PG_MODULE_MAGIC;
> > #endif
>
> Why the conditional compilation of PG_MODULE_MAGIC?

That's the recommendation, so the module compiles on all versions of
Postgres.

> > ERROR:  incompatible library "G:/PostgreSQL/8.3/lib/pgExampleSPI.dll":
> > missing magic block
> > TIP:  Extension libraries are required to use the PG_MODULE_MAGIC macro.

My guess is that the installed server headers are not compatable with
th eversion of postgresql installed.

Have a nice day,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patriotism is when love of your own people comes first; nationalism,
> when hate for people other than your own comes first.
>                                       - Charles de Gaulle