Moving it into the plsql would probably help in this case as well:
16/Nov/2006:14:16:02
Error: Ns_PgExec: result status: 7 message: ERROR: deadlock detected
DETAIL: Process 1365 waits for ShareLock on transaction 1032767; blocked by process 1364.
Process 1364 waits for ShareRowExclusiveLock on relation 17591 of database 17233; blocked by process 1365.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."acs_objects" x WHERE "object_id" = $1 FOR UPDATE OF x"
SQL statement "insert into acs_object_context_index (object_id, ancestor_id, n_generations) select $1 as object_id, ancestor_id, n_generations + 1 as n_generations from acs_object_context_index where object_id = $2 "
PL/pgSQL function "acs_objects_context_id_in_tr" line 10 at SQL statement
SQL statement "insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "content_item__new" line 77 at assignment
====
Yes, this is all of the error 😊
