I'm running slony 1.2.8 (Yes, I realize there are newer releases,
just haven't upgraded yet, and glancing over notes, it seems this
wouldn't be a bug.)
So we've got a "master" db which feeds some common general
information to some other systems, which in turn work with and off of
the data. (these guys need their own copy of the data.. and slony
seemed the most logical way to keep that all in sync). The data in
this case is company info (cik, ticker, mcap, etc).
In one case we have a table that as a foreign key w/ondelete cascade
into the replicated table. This works fine - inserting a row into the
table fails if the key isn't there. The problem is if data is
deleted from the replicated table, it seems the ON DELETE CASCADE
part is never done, and I'm left with orphaned nodes in my other tables.
cik is a PK in the companyinfo table, if_portfolio_ciks has a FK to
it (on delete cascade).
PRODUCTION > insert into if_portfolio_ciks (portfolio_id, cik,
dateposted, num_shares) values (20013, 103973, now(), 100);
ERROR: insert or update on table "if_portfolio_ciks" violates
foreign key constraint "if_portfolio_ciks_cik_fkey"
DETAIL: Key (cik)=(103973) is not present in table "companyinfo".
so the FK part is fine.
On the master I inserted a record with cik 1000010266
back on the other box;
PRODUCTION > insert into if_portfolio_ciks (portfolio_id, cik,
dateposted, num_shares) values (20013, 1000010266, now(), 100);
INSERT 0 1
[ I delete the companyinfo record on the master ]
PRODUCTION > select * from if_portfolio_ciks where portfolio_id = 20013;
portfolio_id | cik | dateposted | num_shares
--------------+------------+----------------------------+------------
20013 | 1000010266 | 2007-12-06 15:36:44.598798 | 100
PRODUCTION > select * from companyinfo where cik = 1000010266;
cik | ticker | name | mcap | ....
-----+--------+------+------+--------+-----------+-------------
+----------+----------+----------+-----------+-----------
+-------------+----------+----------+-----------+-------------------
+----------+---------------
(0 rows)
Is this just the nature of the beast. I realize this may not be
entirely under Slonys unbrella of how it is to be used, but I needed
a way to distribute & sync data from a table to a number of other
places. Which slony does do a good job of.
So, anything I can do?
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
