Michael Richards ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
