Emma Lovatt emma.lovatt at ticketline.co.uk
Tue Nov 30 03:36:55 PST 2010
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 


More information about the Slony1-general mailing list