Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CLhHx69548 for ; Mon, 12 Feb 2001 16:43:17 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from mta5.snfc21.pbi.net (mta5.snfc21.pbi.net [206.13.28.241]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1B8Dax53854 for ; Sun, 11 Feb 2001 03:13:37 -0500 (EST) (envelope-from daisuke@wafu.ne.jp) Received: from wafu.ne.jp ([64.168.87.196]) by mta5.snfc21.pbi.net (Sun Internet Mail Server sims.3.5.2000.01.05.12.18.p9) with ESMTP id <0G8L005TF2PNLG@mta5.snfc21.pbi.net> for pgsql-interfaces@postgresql.org; Sun, 11 Feb 2001 00:10:35 -0800 (PST) Date: Sun, 11 Feb 2001 00:14:25 -0800 From: Daisuke Maki Subject: lo_creat problem? To: pgsql-interfaces@postgresql.org Message-id: <3A8649E1.1898CE76@wafu.ne.jp> MIME-version: 1.0 X-Mailer: Mozilla 4.7 [ja] (WinNT; I) Content-type: text/plain; charset=iso-2022-jp Content-transfer-encoding: 7bit X-Accept-Language: ja X-Archive-Number: 200102/100 X-Sequence-Number: 1057 Hi, I don't know if this is a perl issue or not but here's the scenario: Platform: Linux 2.2 kernel (Japanized) Postgres: 7.03 (compiled with --with-perl and --enable-multibyte ) pgsql_perl: 1.90, 1.81 The problem is very simple. All i'm trying to do is to create a Large Object. However, $conn->lo_creat( PGRES_INV_WRITE | PGRES_INV_READ ); $conn->lo_import ( 'some_filename' ); both return an OID of ZERO, no matter what I do. It doesn't even return PGRES_InvalidOID on failure. In fact, the lo_demo.pl, which came with pgsql_perl 1.9, didn't work either. So I don't think it would be a problem on my script. Is this a known issue? Is there a way around it? Any help would be appreciated. Thanks in advance, --d