From 1eeef021c65c85c24d62a0cc1ee4a746a601beb5 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Sun, 2 Jun 2013 13:05:49 +0200 Subject: o Cleaning up dependencies. --- Locking.md | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 Locking.md (limited to 'Locking.md') diff --git a/Locking.md b/Locking.md new file mode 100644 index 0000000..aea1d62 --- /dev/null +++ b/Locking.md @@ -0,0 +1,14 @@ +Test data: + + begin; + drop table x; + create table x(id integer not null primary key, value integer default random() * 1000); + insert into x(id) select * from generate_series(1, 100); + commit; + +Execution: + + rollback; + begin; + select id from (select id from x order by value limit 10) as rows where pg_try_advisory_xact_lock(id); + -- cgit v1.2.3