Disapointed !!

From: François LODIER <zentak(at)agisphere(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Disapointed !!
Date: 2001-01-05 09:31:17
Message-ID: 3A559465.414FEB89@agisphere.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)agisphere(dot)com . __ .
Ouais! Et pourquoi ?? ... .
---------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Chmara 2001-01-05 10:05:36 Re: How passwords can be crypted in postgres?
Previous Message karol 2001-01-05 09:27:56 Re: select distinct null