[QUESTIONS] builtin lo_unlink(int4)? why int4 not oid? - Mailing list pgsql-hackers

From Park, Chul-Su
Subject [QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?
Date
Msg-id 3581E176.2885E0FF@mhlx01.kek.jp
Whole thread Raw
Responses Re: [HACKERS] [QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?  (Peter T Mount <psqlhack@retep.org.uk>)
List pgsql-hackers
Hello all,

e.g.

    I want to delete a large object with this table

CREATE TABLE image (
    name            text,
    raster          oid
);

-- from programmer's guide

in the psql

foo=> select lo_unlink(raster) from image;
ERROR:  function int4(oid) does not exist

Why builtin "lo_unlink" is defined as accepting int4 not oid?  Then do I
have to do
foo=> select lo_unlink(int4(oid_text(raster))) from image;
OR
define "raster" as int4?  I don't think all these are good idea...  Then
how to delete "lo" in the "psql"?

Best Regards,
C.S.Park


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: template names
Next
From: Bruce Momjian
Date:
Subject: Re: [QUESTIONS] How is PostgreSQL doing?