[Bucardo-general] Bucardo

Greg Sabino Mullane greg at endpoint.com
Wed Nov 5 18:13:11 UTC 2008

> INSERT INTO bucardo.herdmap(herd,goat) SELECT 'test_herd', id from
> bucardo.goat where db='test1' and tablename in ('name');
> ERROR:  error from Perl trigger function: relation "herdmap" does not
> exist at line 15.

Looks like the version of the herdcheck() function you have does not have
absolute paths to the herdmap table (it looks as if this has already been
fixed in later versions). You can make sure that function specifies
"bucardo.herdmap" instead of just herdmap, or you can simply set the
search_path before you do all the inserts, like so:

SET search_path = bucardo, public;

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20081105/046b5a09/attachment.bin 

More information about the Bucardo-general mailing list