Unanswered: General question about developing under Windows
I'm wotking with PostgreSQL 8.1.4 under Windows XP. Server was installed from downloaded binaries (I don't build it from sources myself). Now I'm writing external C-lnguage functions.
In documentation it is said to use some header files (like executor/spi.h, postgres.h and e.t.c.) but there are no .lib files to these .h files. I tried to load needed functions from .dll dynamically, but I do get memory read errors sometimes. I gues this is because of using non-recommended linking way.
But if I try to compile some examples from documentation or from /contrib directory, I get "unresolved external symbol" errors from each used function (for example _SPI_connect(), _SPI_finish() and _SPI_exec()).
Don't know how to fix it.
I hope I'm not the only one who develop such functions under Windows : )