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

[Michelle Sullivan]

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/