Hi,
 
Slony gives the following error message when a record is deleted from a table being replicated:
ERROR:  Slony-I: Table newt is replicated and cannot be modified on a subscriber node. This should be because of the triggers defined on the table for update/delete/insert etc.
 
Just out of curiosity, is it possible to implement trigger functionality on events like creating a table or dropping a table? Would that be useful at all? If that is possible, then it would be possible for slony to give an error message when the table is dropped during replication?

Thanks,
Saranya


> The tables got replicated in the test_slave database.
> 
> I tried to drop the one of the tables in test_slave database and it 
> actually allowed to drop the table while it was getting replicated!
>
How would you imagine that Slony-I could prevent you from doing that?

		
---------------------------------
Do you Yahoo!?
 The all-new My Yahoo! – Get yours free!    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050105/28bc003a/attachment.html