copying a large object?

From: "mario" <mweilguni(at)sime(dot)com>
To: "Postgres Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: copying a large object?
Date: 2001-10-24 10:28:58
Message-ID: 009201c15c76$b13bb0e0$80fa0c0a@LTP013356
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm working on an application where it is necessary to make copies of large
objects, and now I wonder if it is safe
to use this (symbolic, somewhat PHP like) code. Say I've a LOB with OID=1234

$oid = db_exec("select lo_create(....)")
db_exec("delete from pg_largeobject where loid=$oid")
db_exec("insert into pg_largeobject select $oid, pageno, data from
pg_largeobject where loid=1234")

is this a safe way to accomplish this?

And another question regarding large objects, as I see the objects are
organized in units of 2048 bytes each. Can I somehow set this to a higher
value like 8k or 32k (I use 32k pages).

I'm using the latest 7.2 cvs version.

Hope someone of you can help me, thanks!

Best regards,
Mario Weilguni

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bill Studenmund 2001-10-24 10:50:16 Re: Proposed new create command, CREATE OPERATOR CLASS
Previous Message Kiran Kumar Gahlot 2001-10-24 10:17:42 check for disk space