[Bucardo-general] Bucardo error

Danil Rakevich danilr at aswsyst.cz
Wed Sep 21 12:15:29 UTC 2016

Please update bucardo.schema file with the following (starting from the 
line 1745):

{ name => 'bucardo_purge_delta', args => 'text', returns => 'text', body 
=> q{
   myrec RECORD;
   myrez TEXT;
   total INTEGER = 0;

   SET LOCAL search_path = pg_catalog;

   -- Grab all potential tables to be vacuumed by looking at 
   FOR myrec IN SELECT DISTINCT tablename FROM 
bucardo.bucardo_delta_targets LOOP
     SELECT INTO myrez
       bucardo.bucardo_purge_delta_oid($1, myrec.tablename);
     RAISE NOTICE '%', myrez;
     total = total + 1;

RETURN 'Tables processed: ' || 

} ## end of bucardo_purge_delta body

It fixes the error:

(20817) [Wed Sep 21 13:57:11 2016] VAC Warning! VAC was killed at line 
7727: DBD::Pg::st pg_result failed: ERROR:  operator is not unique: 
unknown || integer
LINE 1: SELECT 'Tables processed: ' || total
HINT:  Could not choose a best candidate operator. You might need to add 
explicit type casts.
QUERY:  SELECT 'Tables processed: ' || total

Thank you in advance.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160921/645b8f11/attachment.html>

More information about the Bucardo-general mailing list