Re: [BUG] lo_open() makes a warning/falls to an assertion

KaiGai Kohei wrote:

> -- (3) tries to open it with writable mode under transaction block.
> postgres=# BEGIN;
> BEGIN
> postgres=# SELECT lo_open(24576, x'40000'::int);
> WARNING:  Snapshot reference leak: Snapshot 0x96b8488 still referenced

Interesting.  This is due to this patch
http://git.postgresql.org/?p=postgresql.git;a=commit;h=52d70aa5d0cdcdf9ab925fb46024b4b91760ac43

I'm investigating now.  Thanks for the report.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.