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
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 |
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 |