Re: Proposal: new large object API - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal: new large object API
Date
Msg-id 22799.1206114311@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal: new large object API  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Proposal: new large object API
List pgsql-hackers
Tatsuo Ishii <ishii@postgresql.org> writes:
> Ok, here is the revised patch.

This looks sane to me, but I'd suggest leaving out the mention of 8.4
in the docs.  Actually, I'm not sure you need a paragraph at all ---
just adding an example would be enough, I think.
 SELECT lo_unlink(173454);  -- deletes large object with OID 173454  INSERT INTO image (name, raster)     VALUES
('beautifulimage', lo_import('/etc/motd'));
 
+ 
+ INSERT INTO image (name, raster)  -- same as above, but specify OID to use
+     VALUES ('beautiful image', lo_import('/etc/motd', 68583));  SELECT lo_export(image.raster, '/tmp/motd') FROM
image    WHERE name = 'beautiful image'; </programlisting>
 

        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Commit Fest (was Re: Sort Refinement)
Next
From: Tom Lane
Date:
Subject: Re: Commit Fest (was Re: Sort Refinement)