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

From Tatsuo Ishii
Subject Re: Proposal: new large object API
Date
Msg-id 20080322.105639.22515736.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Proposal: new large object API  (Tom Lane <tgl@sss.pgh.pa.us>)
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 ('beautiful image', 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>

Thanks for the comment. I have committed with your suggested doc
changing.
--
Tatsuo Ishii
SRA OSS, Inc. Japan


pgsql-hackers by date:

Previous
From: alfranio@lsd.di.uminho.pt
Date:
Subject: Re: Proposal for db level triggers
Next
From: Shane Ambler
Date:
Subject: Re: serial arrays?