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
pgsql-bugs by date
|Next:||From: ag20||Date: 2001-10-03 20:49:51|
|Subject: query plan|
|Previous:||From: Steven Mooij||Date: 2001-10-03 10:52:51|
|Subject: \lo_unlink results in "ERROR: pg_description: Permission denied."|