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