Request a Demo
Home   >   mailing lists

Re: Guarantee order of batched pg_advisory_xact_lock - Mailing list pgsql-general

From Tom Lane
Subject Re: Guarantee order of batched pg_advisory_xact_lock
Date
Msg-id 101916.1770850197@sss.pgh.pa.us
Whole thread Raw
In response to Re: Guarantee order of batched pg_advisory_xact_lock  (Nico Heller <nico.heller@posteo.de>)
Responses Re: Guarantee order of batched pg_advisory_xact_lock
List pgsql-general
Tree view 
Nico Heller <nico.heller@posteo.de> writes:
> So it would probably be better to ORDER BY the hashtextended result 
> instead of :keysToLock, right?

Yeah, that seems like it'd work, if you have no other dependencies
on the locking order.

            regards, tom lane

pgsql-general by date:

Previous
From: Nico Heller
Date:
Subject: Re: Guarantee order of batched pg_advisory_xact_lock
Next
From: Nico Heller
Date:
Subject: Re: Guarantee order of batched pg_advisory_xact_lock