Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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


  • From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
  • To: "Mehul Doshi-A20614" <mehul(at)motorola(dot)com>, <pgsql-hackers-win32(at)postgresql(dot)org>
  • Subject: Re: Query on support for trigger functions defined in a Shared library in Windows
  • Date: Mon, 25 Jul 2005 17:14:57 +0200
  • Message-id: <6BCB9D8A16AC4241919521715F4D8BCE6C77C4@algol.sollentuna.se> <text/plain>

> 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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group