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

[Michelle Sullivan]

Michelle Sullivan wrote:
> 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)

FYI, you might want to take a look at:

http://www.postgresql.org/docs/8.4/interactive/ddl-schemas.html

When the schemas and search paths are the same you should get the same
results for querying the tables.  Alter the table to use the full path
or no path if necessary.

Best,

Michelle