How to insert into pg_largeobject?

From: Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)yu>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to insert into pg_largeobject?
Date: 2008-09-04 08:25:36
Message-ID: 48BF9B80.2070702@etf.bg.ac.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2008-09-04 11:56:35 Re: How to insert into pg_largeobject?
Previous Message Jason Dusek 2008-09-04 07:08:39 Re: telnet examples