[QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?

Поиск
Список
Период
Сортировка
От Park, Chul-Su
Тема [QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?
Дата
Msg-id 3581E176.2885E0FF@mhlx01.kek.jp
обсуждение исходный текст
Ответы Re: [HACKERS] [QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?  (Peter T Mount <psqlhack@retep.org.uk>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: template names
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [QUESTIONS] How is PostgreSQL doing?