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
