agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] create oid and WARNING
Date: Fri, 22 Jul 2005 12:18:52 +0200
Message-ID: <thhal-0jmC8A2kD77Q6IkPy/ST4O+j3dLn8GG@mailblocks.com> (raw)
In-Reply-To: <6C58E66DB3DDCshun@datasection.co.jp>
References: <6C58E66DB3DDCshun@datasection.co.jp>
<42E0C80C.5060802@mailblocks.com>
<thhal-0jmC8A2cD77QTovpfv8d56h5FKHNW61@mailblocks.com>
Probably a PostgreSQL bug that has been fixed in later versions. Post a
query to the pgsql-hackers at postgresql.org and ask about the warnings.
Perhaps they can give you more info.
Regards,
Thomas Hallgren
Shunsuke Ikegami wrote:
>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
>>
>>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
view thread (3+ messages) latest in thread
Message-ID: <thhal-0jmC8A2kD77Q6IkPy/ST4O+j3dLn8GG@mailblocks.com>
Permalink: ../thhal-0jmC8A2kD77Q6IkPy%2FST4O+j3dLn8GG@mailblocks.com/
Also on: postgresql.org/message-id/thhal-0jmC8A2kD77Q6IkPy/ST4O+j3dLn8GG@mailblocks.com
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: <thhal-0jmC8A2kD77Q6IkPy/ST4O+j3dLn8GG@mailblocks.com>
* 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