Hi,
I'm still thinking on the problem of transferring data to a 2nd database.
I've learnt some things but some are too complex....
Now I'm thinking of executing an external program (written in delphi) with a
(untrusted) Procedural Language on the event of a trigger.
Thus something like
"
CREATE FUNCTION transfer_to_db2 RETURNS TRIGGER $$
execute(....../transfer_to_db2.exe);
$$ LANGUAGE ..........
"
Is this possible?
I know i can install a language in pg, but i prefer an extrenal program (so
i can connect it with pg and nobody else has to worry about pg).
Thanks,
Kristoff