agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] create oid and WARNING
Date: Fri, 22 Jul 2005 11:41:26 +0900
Message-ID: <6C58E66DB3DDCshun@datasection.co.jp> (raw)

Hello,

I tried to use LargeObject with PL/Java.
When I create oid, I receive WARNING message.
Oid is OK.

- pljava-1.1.0
- psql (PostgreSQL) 7.4.7
- java version "1.4.2_04"
- Fedora Core 2

When I tried with psql 8.0.3, I don't receive WARNING.
Do you have some idea?


--- I tried. ---
import java.sql.SQLException;
import java.util.logging.Logger;

import org.postgresql.pljava.internal.LargeObject;

public class CreateOidTest {
    public static int createOid() {
        try {
            LargeObject obj = LargeObject.create(LargeObject.INV_WRITE);
            Logger.getAnonymousLogger().info("create OID");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        
        return 1;
    }
}


--- result 

Jul 22 10:12:45 tsukuyomi postgres[12885]: [100021-1] WARNING:  relcache 
reference leak: relation "pg_largeobject" has refcnt 2 instead of 0
Jul 22 10:12:45 tsukuyomi postgres[12885]: [100022-1] WARNING:  relcache 
reference leak: relation "pg_largeobject_loid_pn_index" has refcnt 2 instead 
of 0

----

Regards,
Shunsuke Ikegami


>Shunsuke,
>The LargeObject support in PL/Java is experimental and in the current 
>version, the C-code will not be initialized (hence the error that you 
>get). The code is there though, and if you want to play around with it, 
>my guess is that the only thing you need to do in order to get it to 
>work is to add the line:
>
>    LargeObject_initialize(fcinfo);
>
>somewhere near the end of function Type_initialize in the file 
>pljava/type/Type.c, recompile and try again.
>
>Regards,
>Thomas Hallgren

view thread (3+ messages)  latest in thread

Message-ID: <6C58E66DB3DDCshun@datasection.co.jp>
Permalink:  ../6C58E66DB3DDCshun@datasection.co.jp/
Also on:    postgresql.org/message-id/6C58E66DB3DDCshun@datasection.co.jp

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] create oid and WARNING
  In-Reply-To: <6C58E66DB3DDCshun@datasection.co.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox