Le Mon, 28 Mar 2016 12:44:51 +0200, Emre Hasegeli <emre@xxxxxxxxxxxx> a écrit : > > Could I use lock tables to fix this? Is postgres automaticaly locking a > > table while running a trigger on that table? > > You can use LOCK TABLE. See the documentation: > > http://www.postgresql.org/docs/current/static/explicit-locking.html Use advisory locks for better performance. See the following article (at least the two lasts chapters) for some examples: http://blog.ioguix.net/postgresql/2015/02/05/Partitionning-and-constraints-part-1.html Cheers, -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
