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=FALSE
);
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=FALSE
);
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=FALSE
);
ALTER TABLE services.t_schema_objects_rastplaetze OWNER TO zaunerj;

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to