[Bucardo-general] Bucardo error on TRUNCATE

Christophe Pettus xof at thebuild.com
Sat Jun 18 20:44:45 UTC 2011


I received the following when doing a TRUNCATE on a Bucardo pushsync replicated table:

bs_prod=> truncate bucardo_test;
ERROR:  permission denied for schema bucardo
LINE 1: INSERT INTO bucardo.bucardo_truncate_trigger(tablename,sname...
                    ^
QUERY:  INSERT INTO bucardo.bucardo_truncate_trigger(tablename,sname,tname,sync)
   VALUES (TG_RELID, TG_TABLE_SCHEMA, TG_TABLE_NAME, 'primarydelta')
CONTEXT:  PL/pgSQL function "bucardo_triggerkick_primarydelta" line 4 at SQL statement

Everything validates OK.  Thoughts?
--
-- Christophe Pettus
   xof at thebuild.com



More information about the Bucardo-general mailing list