Thu Sep 10 03:18:01 PDT 2009
- Previous message: [Slony1-general] Does every node really need a path to every othernode?
- Next message: [Slony1-general] Slony 2.0.3RC2 Inherited Table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello, we are using Slony2.03 RC2 and Postgresql 8.4.0 and are Running under = Suse SLES10 (SP2), i've 8 schema's, which i sync with slony, works fine on all normal Tables (are all synchron). I've 4 Tables which are inherited tables, and i get not all table = synchron by slony, services.t_schema_objects_go is synchron, and = services.t_schema_objects_rastplaetze is not synchron( 0 records on = master 170 records) any idea? excample: CREATE TABLE services.t_schema_objects ( id serial NOT NULL, titel character varying(255) CONSTRAINT t_schema_objects_id_pkey PRIMARY KEY (id), ) WITH ( OIDS=3DFALSE ); ALTER TABLE services.t_schema_objects OWNER TO pvis; CREATE TABLE services.t_schema_objects_go ( -- Inherited from table services.t_schema_objects_go: id integer NOT = NULL DEFAULT nextval('services.t_schema_objects_id_seq'::regclass), -- Inherited from table services.t_schema_objects_go: titel character = varying(255), test2 character varying(255), CONSTRAINT t_schema_objects_go_id_pkey PRIMARY KEY (id), ) INHERITS (services.t_schema_objects) WITH ( OIDS=3DFALSE ); ALTER TABLE services.t_schema_objects_go OWNER TO pvis; CREATE TABLE services.t_schema_objects_rastplaetze ( -- Inherited from table services.t_schema_objects_rastplaetze: id = integer NOT NULL DEFAULT = nextval('services.t_schema_objects_id_seq'::regclass), -- Inherited from table services.t_schema_objects_rastplaetze: titel = character varying(255), objectid integer, CONSTRAINT t_schema_objects_rastplaetze_id_pkey PRIMARY KEY (id), ) INHERITS (services.t_schema_objects) WITH ( OIDS=3DFALSE ); ALTER TABLE services.t_schema_objects_rastplaetze OWNER TO zaunerj; -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/x-pkcs7-signature Size: 5226 bytes Desc: S/MIME Cryptographic Signature Url : http://lists.slony.info/pipermail/slony1-general/attachments/20090910= /3812f114/smime.bin
- Previous message: [Slony1-general] Does every node really need a path to every othernode?
- Next message: [Slony1-general] Slony 2.0.3RC2 Inherited Table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list