Re: Query on support for trigger functions defined in a Shared library in Windows

> Hi,
> 
> I would like to know whether the native Windows version of 
> PostgreSQL (version 8.0.0) supports trigger functions defined 
> in shared libraries. Specifically, I am trying to port a 
> Linux shared object used as the snippet below shows to Windows:
> 
> CREATE FUNCTION foo() returns trigger AS 
> '/path/to/sharedlib.so' LANGUAGE C;
> 
> Are DLLs supported in a similar context in Windows?

Yes, they should be.


> What do I need to do to port such code?

Most functions should work without modifications.


> My initial attempts resulted in a failure. I created the DLL 
> and attempted to run the SQL CREATE FUNCTION which specified 
> the Windows path to the DLL. However the server died without 
> any clueful messages.

How exactly did you build your DLL?

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend