Hi All,
First I will explain what I try to do:
I’d like to synchronize more or less two databases, in a third database. I mean, I want to book keep when an object has arrived in both databases. (In one database I am allowed to use trigger function but not in the other)
1) Postgres (maintenance database)
2) Database1
3) Database3
How can I set up in a cron job (pgagent), that I check if a certain value f.e. id is present in both database1 database2 and then flag this in the maintenance database?
Select_connect(‘myconnect’, ‘dbase=database1’);
Select_connect(‘myconnect2’,’dbase=database2’);
Using
select dblink('myconnect',….????
Thanks in advance!
Jan
