Hi, all
I am always on this problem of calling a function from a c libraire in psql and I found somethig very strange. In order to make me understand I will try to describe you all the stuff :
I have got two databases which can be on the same or on different computer. One I call the client database and the other the server database. The server database manages the mail of some entries in the client database (which contains the information about the user).
So I wanted to create trigger in order to update information on the server databse when a change is done on the client database.
This trigger on the client should call a c function that make the chage on the server database.
The problem is that when I call this function from the trigger it makes a strange request on the client database and the server postmaster blocks at the "Initpostgres". To make sure it was not the trigger I created, with the same sources, a simple sql function, and had the same result that I had whith the trigger.
So I wrote a very short c function that calls the library that I created for postgres to make sure that the library works fine. And it does !
I must say that I am totally dispointed. If any one could help he would be welcome.
--
--------------------------------
François Lodier . _
. __ .
. .. ...
zentak@agisphere.com . __ .
Ouais! Et pourquoi ?? ... .
---------------------------------