<div class="Section1"><p class="MsoNormal">Hi All,<p class="MsoNormal"> <p class="MsoNormal">First I will explain what
Itry to do:<p class="MsoNormal"> <p class="MsoNormal">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
triggerfunction but not in the other)<p class="MsoNormal"> <p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0level1 lfo1"><span style="mso-list:Ignore">1)<span style="font:7.0pt "Times New
Roman""> </span></span>Postgres (maintenance database)<p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l0level1 lfo1"><span style="mso-list:Ignore">2)<span style="font:7.0pt "Times New
Roman""> </span></span>Database1<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1
lfo1"><spanstyle="mso-list:Ignore">3)<span style="font:7.0pt "Times New Roman""> </span></span>Database3<p
class="MsoNormal">Howcan I set up in a cron job (pgagent), that I check if a certain value f.e. id is present in both
database1database2 and then flag this in the maintenance database? <p class="MsoNormal"> <p
class="MsoNormal">Select_connect(‘myconnect’,‘dbase=database1’);<p
class="MsoNormal">Select_connect(‘myconnect2’,’dbase=database2’);<pclass="MsoNormal"> <p class="MsoNormal">Using <p
class="MsoNormal">selectdblink('myconnect',….????<p class="MsoNormal"> <p class="MsoNormal">Thanks in advance!<p
class="MsoNormal"> <pclass="MsoNormal">Jan</div>
