[ sorry for slow response ]
Stephen Rees writes:
> Code that works on Pg8.3 raises an error on Pg9.1, is this a bug?
Yes, it sure looks that way. Somebody decided they could mark userlocks
as transactional, which was probably a bad idea altogether, and
certainly wasn't followed up on adequately
Code that works on Pg8.3 raises an error on Pg9.1, is this a bug?
PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC
gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2
select pg_try_advisory_lock(123);
pg_try_advisory_lock
--
t
(1 row)
postgres=# begin transaction;
BEGIN
p
