[Bucardo-general] Sync issues with unaccent function
fernandowiek at gmail.com
Thu Feb 22 18:20:29 UTC 2018
I configured an RDS Postgres as source and EC2 Postgres as target on
Bucardo 5.5.0. Everything is ok until I tried to create a sync. When I do
this, I get this error:
"WARNING: Issuing rollback() due to DESTROY without explicit disconnect()
of DBD::Pg::db handle dbname=XXXX;host=XXXXX;port=5432 at -e line 56.
Failed to add sync: DBD::Pg::st execute failed: ERROR: DBD::Pg::db do
failed: ERROR: function unaccent(unknown, text) does not exist
LINE 2: SELECT lower(unaccent('public.unaccent', $1))
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT lower(unaccent('public.unaccent', $1))
CONTEXT: SQL function "asciify" during inlining at line 128. at line 30.
CONTEXT: PL/Perl function "validate_sync" at /usr/local/bin/bucardo line
The extension unncent is working fine on both sides. Anyone could help me
to find the issue?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general