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