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

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

From: Steven Mooij <steven(dot)mooij(at)kavezet(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: \lo_unlink results in "ERROR: pg_description: Permission denied."
Date: 2001-10-03 10:52:51
Message-ID: 20011003125251.A2156@elmo (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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.".

I couldn't find anything in the documentation about large objects and their
expected behaviour, but I expected the lo to be deleted instead of this
error. The version of postgresql I use:
PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4

It is installed using the debian installation package postgres (
7.1release-4). Only I changed the data-directory (copied all files to
/home/postgres and created a softlink from /var/lib/postgres to
/home/postgres, while postgresql was not running.)

For me this was only a testdatabase, so for me it is not an urgent problem,
but I hope this can be solved.


Steven Mooij
Kavezet Automatisering
Korvezeestraat 37
2628DB Delft

Telefoon:	+31 6 44960226
Email:		steven(dot)mooij(at)kavezet(dot)com
ICQ:		63799400


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-10-03 14:41:08
Subject: Re: \lo_unlink results in "ERROR: pg_description: Permission denied."
Previous:From: Ronald KuczekDate: 2001-10-02 06:55:07
Subject: SPI linking problems on Win32

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