From: | Mehul Doshi-A20614 <mehul(at)motorola(dot)com> |
---|---|
To: | "'Magnus Hagander'" <mha(at)sollentuna(dot)net>, pgsql-hackers-win32(at)postgresql(dot)org |
Cc: | Mehul Doshi-A20614 <mehul(at)motorola(dot)com> |
Subject: | Re: Query on support for trigger functions |
Date: | 2005-07-27 13:35:28 |
Message-ID: | 45AAAAED8B10F547878F52FE15C57C5D15D050@zin24exm03.corp.mot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-07-27 20:02:54 | Re: Query on support for trigger functions defined in a Shared library in Windows |
Previous Message | Magnus Hagander | 2005-07-26 13:03:49 | Re: libpq request results |