Summary: | replicate_partition stored procedure doesn't start replicating changes to the new table | ||
---|---|---|---|
Product: | Slony-I | Reporter: | Steve Singer <ssinger> |
Component: | stored procedures | Assignee: | Slony Bugs List <slony1-bugs> |
Status: | RESOLVED WORKSFORME | ||
Severity: | enhancement | CC: | slony1-bugs |
Priority: | low | ||
Version: | 2.0 | ||
Hardware: | PC | ||
OS: | Linux | ||
URL: | http://slony.info/documentation/2.0/partitioning.html |
Description
Steve Singer
2010-07-27 08:27:45 UTC
I'm responsible for that one... The missing piece is that that particular function expects to be run via EXECUTE SCRIPT. If it is run thus, then it gets run on each node (so there's no need for a further event). There may need to be some remediation relating to alterTableRestore(). Defer to 2.0.6. The documentation on partitioning is reasonably clear that this is to be run as part of an EXECUTE SCRIPT request, so it runs against all nodes. I'll augment the functions' documentation to indicate the same. Head: http://git.postgresql.org/gitweb?p=slony1-engine.git;a=commit;h=5bd032e4942c71ee5ae23d7b6c263c8b8a598fb8 2.0: http://git.postgresql.org/gitweb?p=slony1-engine.git;a=commit;h=56e603a5bfe876186afe4ef0b5f443f0c95c3411 |