what is "a standalone session" , connect db with a different ip ?
2017-06-08 0:30 GMT+08:00 Greg Sabino Mullane <[email protected]>: > On Tue, Jun 06, 2017 at 10:23:58AM +0800, 张远 wrote: > > In my postgresql log I can see “CREATE TRIGGER > "bucardo_note_trunc_liyan" > > AFTER TRUNCATE ON "public"."bookmark" > > FOR EACH STATEMENT EXECUTE PROCEDURE > bucardo.bucardo_note_truncation('liyan’)” this sql is blocked by a > select sql. > > Postgres requires a heavy lock on a table to add triggers, but your regular > database activity is blocking that. You could try creating that trigger > in a standalone session by simply running the SQL above. As long as the > function > already exists, it can be created at any time. > > -- > Greg Sabino Mullane [email protected] > End Point Corporation > PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
