Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steven Mooij <steven(dot)mooij(at)kavezet(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: \lo_unlink results in "ERROR: pg_description: Permission denied."
Date: 2001-10-03 14:41:08
Message-ID: 24150.1002120068@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Steven Mooij <steven(dot)mooij(at)kavezet(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: ag20Date: 2001-10-03 20:49:51
Subject: query plan
Previous:From: Steven MooijDate: 2001-10-03 10:52:51
Subject: \lo_unlink results in "ERROR: pg_description: Permission denied."

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group