[Bucardo-general] Bucardo error on TRUNCATE

[Christophe Pettus]

On Jun 18, 2011, at 1:53 PM, Greg Sabino Mullane wrote:
> I think this is because the "triggerkick" functions used to only 
> do NOTIFY, but then we added an INSERT on truncate, but did not 
> set the function as "SECURITY DEFINER". To fix you can add the 
> SECURITY DEFINER phrase to the bucardo.schema file around line 1567, 
> right after:
> 
>  $SQL = qq{
>    CREATE OR REPLACE FUNCTION bucardo."$func0"()
>    RETURNS TRIGGER
>    LANGUAGE plpgsql
> 
> To fix existing installs, you'll need to manually adjust them, like so:
> 
> ALTER FUNCTION bucardo.bucardo_triggerkick_syncname() SECURITY DEFINER;

Works like a charm, thanks!

--
-- Christophe Pettus
   xof at thebuild.com