How to insert into pg_largeobject?

Поиск
Список
Период
Сортировка
От Ognjen Blagojevic
Тема How to insert into pg_largeobject?
Дата
Msg-id 48BF9B80.2070702@etf.bg.ac.yu
обсуждение исходный текст
Ответы Re: How to insert into pg_largeobject?  ("Sean Davis" <sdavis2@mail.nih.gov>)
Список pgsql-novice
Hi,

How can I insert data into pg_largeobject?

When I try:

   INSERT INTO pg_catalog.pg_largeobject(loid, pageno, data) VALUES (4,
1, '\\001\\002\\003\\004');

as a non-superuser, I get:

   ERROR: permission denied for relation pg_largeobject
   SQL state: 42501

Even after I granted privileges like this:

magazine_test=# GRANT ALL ON pg_largeobject TO public;
GRANT
magazine_test=# \dp pg_catalog.pg_largeobject
                   Access privileges for database "magazine_test"
    Schema   |      Name      | Type  |              Access privileges
------------+----------------+-------+---------------------------------------------
  pg_catalog | pg_largeobject | table |
{=arwdRxt/postgres,ognjen=arwdRxt/postgres}
(1 row)


Is the privileges problem here, or something else?

-Ognjen

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

Предыдущее
От: "Jason Dusek"
Дата:
Сообщение: Re: telnet examples
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: How to insert into pg_largeobject?