Bug 243 - Health Checks for foreign keys
Summary: Health Checks for foreign keys
Status: NEW
Alias: None
Product: Slony-I
Classification: Unclassified
Component: core scripts (show other bugs)
Version: devel
Hardware: All All
: low enhancement
Assignee: Slony Bugs List
URL:
Depends on:
Blocks:
 
Reported: 2011-10-05 14:59 UTC by Christopher Browne
Modified: 2011-10-05 14:59 UTC (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher Browne 2011-10-05 14:59:10 UTC
We should look for foreign key relationships that cross set boundaries from various perspectives:

1. Foreign key on replicated table pointing to a non-replicated table
2. Foreign key on non-replicated table pointing to a replicated table
3. Foreign key on replicated table pointing to a table in a different replication set with the same origin
4. Foreign key on replicated table pointing to a table in a different replication set with a different origin

Other scenarios are uninteresting from a Slony perspective.

There are several ways that these issues might be reported, and we may wish to consider using some or multiple of the following:

a) Initial health check run by slon upon startup, calling stored function slon_node_health_check() 

b) The tool test_slony_state.pl

c) Perhaps a stand-alone tool to add to tools