logo       
Google Custom Search
    AddThis Social Bookmark Button

How to update Remote DB using trigger?: msg#00017

Subject: How to update Remote DB using trigger?
Hi,

I am using two Postgre databases in my application. Both are in different in
machine.
My requirement is that when one database(primary) gets updated then the
another database(secondary) should also get updated with the same
information updated in primary database.
I think trigger will help in this.
But I am not sure about the connection to remote database from stored
procedure.
Can anyone help me?

Regards,
Natrayan.
DISCLAIMER 
This message and any attachment(s) contained here are information that is 
confidential, proprietary to HCL Technologies 
and its customers. Contents may be privileged or otherwise protected by law. 
The information is solely intended for the 
individual or the entity it is addressed to. If you are not the intended 
recipient of this message, you are not authorized to 
read, forward, print, retain, copy or disseminate this message or any part of 
it. If you have received this e-mail in error, 
please notify the sender immediately by return e-mail and delete it from your 
computer


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster




Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>