Thread: Deleting large object from table pg_largeobject

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=> 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)

== If I try to delete it directly
fletcher=> delete from pg_largeobject where loid = (     select text from md_blob         where blob_id = 4 );

ERROR:  pg_largeobject: permission denied

fletcher=> delete from pg_largeobject where loid =
292470;                                        
ERROR:  pg_largeobject: permission denied

== If I try to delete all reference to it before, and then delete it
fletcher=> DELETE FROM md_blob WHERE blob_id='4';
DELETE 1

fletcher=> delete from pg_largeobject where loid = 292470;
ERROR:  pg_largeobject: permission denied
fletcher=> 

Anybody know what I am doing wrong? 

My ultimate goal is to delete the largeobject when I delete the row in
md_blob;

here is my system:
RedHat Linux 7.3
PostgreSQL 7.3.2 
JDBC driver from postgresql (v 7.3 with the property ?compatible=7.1 )
Java 1.3

thanks

david

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=> 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)
>
> == If I try to delete it directly
> fletcher=> delete from pg_largeobject where loid = (
>         select text from md_blob
>             where blob_id = 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
Interfaces : JDBC : extensions.

With psql you probably want \lo_unlink

HTH
--  Richard Huxton