Hi Magnus,
Thanks. That helped me. I used MingW to compile the code. I still used 8.0.0
because it is the version that we are currently working on. I will migrate
to 8.0.3 once I am Able to validate the entire setup.
I did get another problem, if you could help me out, it would be great.
Problem Description:
1) I generated the dll using the code.
2) Added the following in postgresql.conf:
dynamic_library_path = 'C:\test\lib,$libdir'
The above didn't work so I went ahead and copied the dll into
C:\Program Files\PostgreSQL\8.0\lib\
3) I restarted the postmaster both times. I got this error both times.
:25: ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/lib/testtrigfuncs.dll": dynamic load error
The log shows:
2005-07-26 22:38:07 DEBUG: InitPostgres
2005-07-26 22:38:07 DEBUG: StartTransaction
2005-07-26 22:38:07 DEBUG: name: unnamed; blockState: DEFAULT; state:
INPROGR, xid/subid/cid: 33475/1/0, nestlvl: 1, children: <>
2005-07-26 22:38:07 DEBUG: CommitTransaction
2005-07-26 22:38:07 DEBUG: name: unnamed; blockState: STARTED; state:
INPROGR, xid/subid/cid: 33475/1/0, nestlvl: 1, children: <>
2005-07-26 22:38:07 DEBUG: StartTransactionCommand
2005-07-26 22:38:07 DEBUG: StartTransaction
2005-07-26 22:38:07 DEBUG: name: unnamed; blockState: DEFAULT; state:
INPROGR, xid/subid/cid: 33476/1/0, nestlvl: 1, children: <>
2005-07-26 22:38:07 DEBUG: ProcessUtility
2005-07-26 22:38:07 DEBUG: find_in_dynamic_libpath: trying "C:/Program
Files/PostgreSQL/8.0/lib/testtrigfuncs.dll"
2005-07-26 22:38:07 ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/lib/testtrigfuncs.dll": dynamic load error
2005-07-26 22:38:07 DEBUG: proc_exit(0)
2005-07-26 22:38:07 DEBUG: shmem_exit(0)
2005-07-26 22:38:07 DEBUG: exit(0)
However, when I ran the newly compiled postgres code (along with my test dll
in /usr/local/pgsql/lib) via msys. It didn't give me any such errors and
everything worked out fine. I don't know what I need to do to make this dll
which I built run with the already installed version of PostgreSQL (8.0.0).
I can upgrade it to 8.0.3 if it solves the problem.
Please let me know. Thanks & have a nice day.
Thanks & Regards,
Mehul