Re: \lo_unlink results in "ERROR: pg_description: Permission denied."

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: \lo_unlink results in "ERROR: pg_description: Permission denied."
Дата
Msg-id 24150.1002120068@sss.pgh.pa.us
обсуждение исходный текст
Ответ на \lo_unlink results in "ERROR: pg_description: Permission denied."  (Steven Mooij <steven.mooij@kavezet.com>)
Ответы Re: \lo_unlink results in "ERROR: pg_description: Permission
Список pgsql-bugs
Steven Mooij <steven.mooij@kavezet.com> writes:
> After I've imported a huge file (1.3 GB) with "\lo_import", listed it with
> "\lo_list" and tried to delete it with "\lo_unlink", I get the error:
> "ERROR:  pg_description: Permission denied.".

Yeah, this is a known bug.  You can do the delete as superuser ...

Peter, what do you think of hacking psql to only try the pg_description
actions if pset.issuper?  The alternative is to invent COMMENT ON LARGE
OBJECT, which is more work than I have time for at the moment.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Steven Mooij
Дата:
Сообщение: \lo_unlink results in "ERROR: pg_description: Permission denied."
Следующее
От: "ag20"
Дата:
Сообщение: query plan