[Bucardo-general] Eek - can't figure out how to fix this one....

[Michelle Sullivan]

Karl Denninger wrote:
> So I have a database I want to replicate.
> 
> I set up Bucardo, and tell it about both database copies - the master
> and the remote.  All appears ok.
> I add all the tables and sequences to a herd.

<snip>

> [Sun Aug  1 12:44:23 2010]  MCP Warning: Source database for sync "fapforum"
> has column "ordinal" of table "public.post_thread" with a DEFAULT of
> "nextval
> ('public.post_thread_ordinal_seq'::regclass)", but target database
> "replicated_fap" has a DEFAULT of
> "nextval('post_thread_ordinal_seq'::regclass)"
> [Sun Aug  1 12:44:23 2010]  MCP Validation of sync fapforum FAILED
> 
> And that's that - bang.
> 
> A look at both shows that I did not intentionally specify the "public"
> schema in either case.  In any event trying to specify it doesn't do me
> a bit of good, nor does recreating the default value without the
> "public" tag in front.  I still get the same error - the system sees the
> "public " schema prefix on the local copy, but not on the remote one,
> whether I have it explicitly specified or not, and as a result it won't
> validate and start the copy.
> 
> I'm stuck here..... this looks like an interesting alternative to SLONY,
> but first I have to get it running :-)


What postgres versions and OS's are you using?  What's your search path
(for schemas)

Michelle