RE: pg_dumplo, thanks :) (fwd)

At 06:42 PM 4/6/00 +0200, Karel Zak wrote:
>
>On Thu, 6 Apr 2000, Peter Mount wrote:
>
>> In the past I had thought of writing something similar as an example for
>> JDBC (dump the LO's into a zip file). The thing I couldn't fathom (and
>> now I'm saying this, it's probably a simple thing to do), was the
>> restore. How do you create an lo with a specific oid?
>
> Very good question. IMHO is not method (in standard API) how create LO with
>a specific oid. The pg_dumplo during LO-dump import rewrite (UPDATE) your
old
>oid in defined column. Yes, you must not use LO's oid as join key between
>tables or save LO's oid to the others columns than you defined in pg_dumplo
>command line.
>
> The TOAST is deliverance from this limitation.

We could actually deliver ourselves from this limitation absent TOAST, if
we wanted, by using something other than the OID as the key for the created
LO item. In fact, this is sorta what I did for my BLOB-ish AOLserver hack
for our web toolkit, but I don't use the actual lo code for a variety of
reasons.

But I looked at it pretty thoroughly...

Since TOAST's on the horizon, I didn't have any real motivation or interest
in working up a less restrictive lo implementation and don't think there's
any real reason to do so. But, LO's dependence on OIDs is an implementation
artifact that's not at all necessary.

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.