Thanks, worked! I definitely need another coffee! Nina
-----Original Message----- From: Michelle Sullivan [mailto:[email protected]] Sent: September-18-13 12:04 To: Markova, Nina Cc: [email protected] 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/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
