Subject: Deleting large object from table pg_largeobject
From: David <cyberguard@sympatico.ca>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 12 Mar 2003 15:59:37 -0500
Message-Id: <1047502777.1661.553.camel@localhost.localdomain>
Mime-Version: 1.0


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