Tue Nov 30 03:36:55 PST 2010
- Previous message: [Slony1-general] Rapid-fire updates to table missed by slony
- Next message: [Slony1-general] Replication breaking on a table and can you replicate certain parts of a table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I've been searching the web for the answer to my questions but cannot find it and was hoping that someone might be able to help or point me in the right direction We have an issue where replication is breaking on one of our tables which has the following format Field Name Type Length Allow Null Seating_mapid int4 32 NO Name varchar 50 NO Description varchar 50 YES Is_default int4 32 NO Bmap bytea 0 YES Miniature int4 32 NO Spaceid int4 32 NO Capacity int4 32 YES Active int4 32 NO Our entire database is encoding SQL_ASCII. I found that there may be a possibility that the bytea column is not replicating and it is due to the encoding of the database which is SQL_ASCII could anyone confirm this? My second question relates to my first if I cannot replicate my bytea column, I would like to know if it is possible to only replicate parts of a table and miss out certain columns, is this possible? Kind Regards Emma Lovatt ------------------------ This email was scanned by BitDefender. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101130/e5fb304d/attachment.htm
- Previous message: [Slony1-general] Rapid-fire updates to table missed by slony
- Next message: [Slony1-general] Replication breaking on a table and can you replicate certain parts of a table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list