When I first log in to psql as a superuser, the first time I try to use
lo_export (), I get a reference leak warning.  This does not happen on
subsequent attempts.  However I can log out and log back in, and see the
error again the first time I execute the query.

Detail follows.  Please CC responses, I'm not on the list.

user cshobe@prosperity:/home/cshobe
$ psql -U postgres osss
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

osss=# select lo_export (stelpa.images.image, '/tmp/osss.test.png') from
stelpa.images;
WARNING:  relcache reference leak: relation "pg_largeobject" has refcnt 1
instead of 0
WARNING:  relcache reference leak: relation "pg_largeobject_loid_pn_index"
has refcnt 1 instead of 0
 lo_export
-----------
         1
(1 row)

osss=# select lo_export (stelpa.images.image, '/tmp/osss.test.png') from
stelpa.images;
 lo_export
-----------
         1
(1 row)

-- 
Casey Allen Shobe  |  http://casey.allen.shobe.info
  cshobe@osss.net  |  ICQ: 1494523  |  AIM: SomeLinuxGuy

Wed, 22 Sep 2004 10:32:39 -0400 (EDT)
"Casey Allen Shobe" <cshobe@osss.net>
Reproducible relcache reference leak
"Casey Allen Shobe" <cshobe@osss.net> writes:
> When I first log in to psql as a superuser, the first time I try to use
> lo_export (), I get a reference leak warning.

This is fixed post-beta2, I believe.

			regards, tom lane

Fri, 24 Sep 2004 01:10:59 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Reproducible relcache reference leak 