pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

lo_creat problem?
2+ messages / 2 participants
[nested] [flat]

* lo_creat problem?
@ 2001-02-11 08:14 Daisuke Maki <daisuke@wafu.ne.jp>
  2001-02-13 00:37 ` Re: lo_creat problem? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Daisuke Maki @ 2001-02-11 08:14 UTC (permalink / raw)
  To: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: lo_creat problem?
  2001-02-11 08:14 lo_creat problem? Daisuke Maki <daisuke@wafu.ne.jp>
@ 2001-02-13 00:37 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2001-02-13 00:37 UTC (permalink / raw)
  To: Daisuke Maki <daisuke@wafu.ne.jp>; +Cc: pgsql-interfaces

Daisuke Maki <daisuke@wafu.ne.jp> writes:
> Platform: Linux 2.2 kernel (Japanized)
> Postgres: 7.03 (compiled with --with-perl and --enable-multibyte )
> pgsql_perl: 1.90, 1.81

> $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.

Strange.  It works OK for me with the perl5 interface that's distributed
with Postgres 7.0.* ... which calls itself 1.8.0.  Dunno where you got
"1.81" or "1.90" from, but maybe they're broken.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2001-02-13 00:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-11 08:14 lo_creat problem? Daisuke Maki <daisuke@wafu.ne.jp>
2001-02-13 00:37 ` Tom Lane <tgl@sss.pgh.pa.us>

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