Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> The lack of regression tests covering this area is a bit annoying
>> at this point. However, it's hard to see how to test FOR UPDATE
>> until we get some concurrent-sessions support in psql.
> Well, end-to-end testing would e better but we can test that the locks are
> at least being recorded by white-box inspection:
> postgres=# select distinct age(xmax) from tellers;
Huh, that's a cute trick ... and it would answer the immediate problem,
which is to check that the statement did take the row locks it was
supposed to.
regards, tom lane