Modifing Slony replicated tables

I have two databases. First - master, second - slave.
Data from master database copy to slave by means of Slony-I.
When I try to insert or update some data in my slave database tables, I have an error:
Slony-I: Table <table_name> is replicated and cannot be modified on a subscriber node.

Is it possible to modify replicated tables?

Will be thankful for any information.

This message was edited 1 time. Last update was at 23 Nov 2009 04:56:04

Eugenia_L wrote:I have two databases. First - master, second - slave.
Data from master database copy to slave by means of Slony-I.
When I try to insert or update some data in my slave database tables, I have an error:
Slony-I: Table <table_name> is replicated and cannot be modified on a subscriber node.

Is it possible to modify replicated tables?

Will be thankful for any information.

No, you cannot modify the data in replicated tables on the slave.

Thank you for your answer.

So if I want to work with replicated tables in future, I will have to delete cluster.

Eugenia_L wrote:Thank you for your answer.

So if I want to work with replicated tables in future, I will have to delete cluster.

Yes. Replicated tables are exact copies of those on the master, so to modify them on the slave, you must first remove them from the replication cluster.

Thank you for a fast answer.

What are you trying to do? The tables will be receiving updates from the master... what 'modifications' do you want to make?