Tatsuo Ishii wrote:
> Sorry for confusion. My example is under normal PostgreSQL, not under
> HS enabled.
You get the same result in standby:
postgres=# begin;
BEGIN
postgres=# prepare a(int) as insert into foo values($1);
PREPARE
postgres=# SELECT * FROM pg_locks;
locktype │ database │ relation │ page │ tuple │ virtualxid │
transactionid │
classid │ objid │ objsubid │ virtualtransaction │ pid │ mode
│ gra
nted
────────────┼──────────┼──────────┼──────┼───────┼────────────┼───────────────┼─
────────┼───────┼──────────┼────────────────────┼───────┼──────────────────┼────
─────
relation │ 11564 │ 10968 │ │ │ │
│
│ │ │ 2/4 │ 10449 │
AccessShareLock │ t
relation │ 11564 │ 16384 │ │ │ │
│
│ │ │ 2/4 │ 10449 │
RowExclusiveLock │ t
virtualxid │ │ │ │ │ 1/1 │
│
│ │ │ 1/0 │ 10419 │ ExclusiveLock
│ t
virtualxid │ │ │ │ │ 2/4 │
│
│ │ │ 2/4 │ 10449 │ ExclusiveLock
│ t
(4 rows)
this is from a standby.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
