Re: Proposal: new large object API

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal: new large object API
Date: 2008-03-22 01:56:39
Message-ID: 20080322.105639.22515736.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> Tatsuo Ishii <ishii(at)postgresql(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-22 04:08:51 Re: Logging conflicted queries on deadlocks
Previous Message Gregory Stark 2008-03-21 23:11:13 Re: Logging conflicted queries on deadlocks

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-03-22 04:08:51 Re: Logging conflicted queries on deadlocks
Previous Message Gregory Stark 2008-03-21 23:11:13 Re: Logging conflicted queries on deadlocks