Josef Huber [EPCOM IT-Systeme] j.huber at epcom.cc
Thu Sep 10 03:18:01 PDT 2009
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


More information about the Slony1-general mailing list