Content-Type: text/plain;
  charset="utf-8"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: David <cyberguard@sympatico.ca>, pgsql-sql@postgresql.org
Subject: Re: Deleting large object from table pg_largeobject
Date: Fri, 14 Mar 2003 11:02:50 +0000
User-Agent: KMail/1.4.3
References: <1047502777.1661.553.camel@localhost.localdomain>
In-Reply-To: <1047502777.1661.553.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200303141102.50176.dev@archonet.com>

On Wednesday 12 Mar 2003 8:59 pm, David wrote:
> Hello,
>
> I'm trying to delete a large object form the pg_largeobject table but I
> get a  permission denied error (in both psql and with the java JDBC ).
>
> Here is my sql stament in order:
>
> fletcher=3D> SELECT * from md_blob ;
> blob_id |  text  | file_name | mime_type
> ---------+--------+-----------+------------
>        4 | 292470 | 2.jpg     | image/jpeg
>       21 | 292572 | 2.jpg     | image/jpeg
>       22 | 292578 | 2.jpg     | image/jpeg
> (3 rows)
>
> =3D=3D If I try to delete it directly
> fletcher=3D> delete from pg_largeobject where loid =3D (
> 		select text from md_blob
> 			where blob_id =3D 4 );
>
> ERROR:  pg_largeobject: permission denied

Should you not be using the special large-object methods?
I don't use Java, but there's a class mentioned in the manual : Client=20
Interfaces : JDBC : extensions.

With psql you probably want \lo_unlink=20

HTH
--=20
  Richard Huxton