| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | SQL function lo_unlink is not documented |
| Date: | 2001-04-21 01:07:17 |
| Message-ID: | 200104210107.f3L17HI66397@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Michael Richards (michael(at)fastmail(dot)ca) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
SQL function lo_unlink is not documented
Long Description
http://postgresql.readysetnet.com/users-lounge/docs/7.1/programmer/lo-funcs.html
Says:
There are two built-in registered functions, lo_import and lo_export which are convenient for use in SQL queries. Here is an example of their use
CREATE TABLE image (
name text,
raster oid
);
INSERT INTO image (name, raster)
VALUES ('beautiful image', lo_import('/etc/motd'));
SELECT lo_export(image.raster, '/tmp/motd') from image
WHERE name = 'beautiful image';
This should also document the lo_unlink function as being able to remove these BLOBs is also supported. See below.
Sample Code
urdr=# select lo_unlink(6816289);
lo_unlink
-----------
1
(1 row)
No file was uploaded with this report
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-04-21 02:52:58 | Re: lo_import does not check type before performing an import |
| Previous Message | pgsql-bugs | 2001-04-21 00:57:00 | lo_import does not check type before performing an import |