Hi all We are trying to implement replication on postgres 7.2 with java and to effectively run it we need to drop all RI triggers from the slave database, but in case when master database fails, we will be using Slave as the master and would need to restore all these RI triggers back on.
Therefore, what I need to know: is there a way to place these RI triggers back on, please let me have all your ideas, one way is to extract those RI creation scripts from the dump but I need some ideas how to do that, or if you have any other ideas, scripts, anything would be greatly appreciated Thanks Mike http://my.yahoo.com.au - My Yahoo! - It's My Yahoo! Get your own! ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
