| From: | "mario" <mw(at)sime(dot)com> |
|---|---|
| To: | "Postgres Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Make a copy of a large object |
| Date: | 2001-10-24 09:11:03 |
| Message-ID: | 001601c15c6b$ce96cd10$80fa0c0a@LTP013356 |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB SD | 2001-10-24 10:10:30 | Re: Index of a table is not used (in any case) |
| Previous Message | Joe Conway | 2001-10-24 06:53:07 | Re: storing binary data |