Alan Hodgson ahodgson
Fri Mar 4 22:31:01 PST 2005
On Fri, Mar 04, 2005 at 02:28:39PM -0800, Darcy Buskermolen wrote:
> no, nothing native in 1.0.5 I did post an email  to -general some 3 months 
> back or so about a method to do this.
> Basicly you create a table that has oid -> realname mappings you dump that 
> with your data, then you update the reloids in the sl_* tables based on the 
> reverse select (where you get the new reloids for the old relnames).

Yeah I only have 25 tables replicated, getting the new oid's is np.  The
triggers were the problem.  I will try Jan's method this weekend.

Thanks for the help.

-- 
"The only freedom which deserves the name, is that of pursuing our own good
in our own way, so long as we do not attempt to deprive others of theirs,
or impede their efforts to obtain it." -- John Stuart Mill, 1859



More information about the Slony1-general mailing list