Re: C function - Mailing list pgsql-general

From Albe Laurenz
Subject Re: C function
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202181F63@exadv11.host.magwien.gv.at
Whole thread Raw
In response to C function  (Vjy <vijay@iavian.com>)
List pgsql-general
Vjy wrote:
> I wrote a C function that will connect to oracle and do insert.
>
> then I created a trigger that calls this C function for any
> insets/updates on TABLE A
>
> when there is a insert in table A , the C function is not called at
> all, any reason why ?

You will need to provide more information to get a useful answer.

Send the definition of the table together with all constraints,
rules and triggers and the INSERT statement that you run.

After the insert, is the new row in table A?

How did you verify that the function did not get called?

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: Affected # of Rows After TRIGGER/RULE Return
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Couple of question on functions