Skip site navigation (1) Skip section navigation (2)

SQL function lo_unlink is not documented

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-04-21 02:52:58
Subject: Re: lo_import does not check type before performing an import
Previous:From: pgsql-bugsDate: 2001-04-21 00:57:00
Subject: lo_import does not check type before performing an import

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group