Fri Apr 28 15:29:36 PDT 2006
- Previous message: [Slony1-general] Slony1 + reiser + Suse logfile size
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> > try { > create set (id = 999, origin = 1, comment = 'merge set'); > set add table (set id = 999, origin = 1, id = 999, fully qualified >name = '$TAB'); > } > wait for event( origin = all, confirmed = all, wait on = 1, timeout >= 0); > echo 'Added $TAB to temporary set'; > > subscribe set (id = 999, provider = 1, receiver = 2, forward = no); > wait for event( origin = all, confirmed = all, wait on = 1, timeout >= 0); > echo 'Subscribed $TAB'; > > merge set (id = 667, add id = 999, origin = 1); > wait for event( origin = all, confirmed = all, wait on = 1, timeout >= 0); > echo 'Merged $TAB'; If you are going to use a variable for a table name, _do not_ enclose it in quotes. In your case, slony is now looking for a table named $TAB. The correct statement should be set add table (set id = 999, origin = 1, id = 999, fully qualified name = $TAB); Good luck, and may the bytes be with you. -------------- next part -------------- A non-text attachment was scrubbed... Name: mdavidson.vcf Type: text/x-vcard Size: 300 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060428/b86c9ab2/mdavidson.vcf
- Previous message: [Slony1-general] Slony1 + reiser + Suse logfile size
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list