[Bucardo-general] FW: removing a sync and triggers - help

[Markova, Nina]

Thanks, worked! I definitely need another coffee!

Nina

-----Original Message-----
From: Michelle Sullivan [mailto:michelle at sorbs.net] 
Sent: September-18-13 12:04
To: Markova, Nina
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] FW: removing a sync and triggers - help

Markova, Nina wrote:
> Hello again,
>
> I found the triggers related to the deleted  sync ***sta_sync_Ms3_So2_s2***   but can't delete them. They were on the other master. 
>
> Triggers:
>  "bucardo_note_trunc_sta_sync_Ms3_So2_s2" AFTER TRUNCATE ON site FOR EACH STATEMENT EXECUTE PROCEDURE bucardo_note_truncation('sta_sync_Ms3_So2_s2')
>
>  "bucardo_kick_sta_sync_Ms3_So2_s2" AFTER INSERT OR DELETE OR UPDATE OR TRUNCATE ON site FOR EACH STATEMENT EXECUTE PROCEDURE  "bucardo_kick_sta_sync_Ms3_So2_s2"()
>
> Commands:
>    drop trigger bucardo_kick_sta_sync_Ms3_So2_s2 on site \g
> ERROR:  trigger "bucardo_kick_sta_sync_ms3_so2_s2" for table "site" does not exist
>
>    drop trigger bucardo_note_trunc_sta_sync_Ms3_So2_s2 on site \g
> ERROR:  trigger "bucardo_note_trunc_sta_sync_ms3_so2_s2" for table "site" does not exist
>
> I tried as user 'postgres' and user 'bucardo'.
>
> Any help will be appreciated,
> Nina
>   

   drop trigger "bucardo_kick_sta_sync_Ms3_So2_s2" on site;

(you have caps in the name so the relation has to be put in quote marks as postgres will automatically change it to lower case - which you can see it  did in the error: trigger "bucardo_kick_sta_sync_ms3_so2_s2" for table "site" does not exist )
 

Regards,


-- 
Michelle Sullivan
http://www.mhix.org/