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 │ trelation │ 11564 │ 16384 │ │ │ │ │ │ │ │ 2/4
│ 10449 │
RowExclusiveLock │ tvirtualxid │ │ │ │ │ 1/1 │ │ │ │ │ 1/0
│ 10419 │ ExclusiveLock │ tvirtualxid │ │ │ │ │ 2/4 │ │ │
│ │ 2/4 │ 10449 │ ExclusiveLock │ t
(4 rows)
this is from a standby.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com