Re: C-functions using SPI Missing Magic Block Error

On 07/02/2010 08:36 AM, Saitenheini(at)web(dot)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/docs/8.2/interactive/xfunc-c.html
>
> I don't have more ideas.
> What could I do?

Building extensions on Windows is a royal pain (at least for me it is).
I would suggest either:

a) switch to Linux (I know, probably not a helpful suggestion)

-or-

b) possibly try adding your function to an existing contrib, e.g.
tablefunc, and see if you can compile that

The build infrastructure on Windows with VC++ is difficult to work with.
In order to get PL/R to compile with VC++ I had to hack the provided
perl build scripts. That could be a third option for you, but (b) is
probably far easier for you.

Joe