[Bucardo-general] noob postgres question

[Selena Deckelmann]

Hi!

Goran Gugic wrote:
> After installing 4.4.0 I see these warnings:
>   Warning: Source database for sync "swc1" has column "id" of table
> "public.table" with a DEFAULT of
> "nextval('public.table_id_seq'::regclass)", but target database
> "client1" has a DEFAULT of "nextval('table_id_seq'::regclass)"
>
> So, the noob postgres question is: how to control if postgres puts the
> schema name in sequence name?
> Alternatively, is there a way to bypass these kind of checks? (I have
> set strict checking to off)

This looks like a search_path issue for the 'bucardo' user.  Verify that your search path is the 
default on both systems. You can set it to the default with:

ALTER ROLE bucardo SET search_path TO DEFAULT;

-- 
Selena Deckelmann
End Point Corporation
selena at endpoint.com