Deleting large object from table pg_largeobject

From: David <cyberguard(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Deleting large object from table pg_largeobject
Date: 2003-03-12 20:59:37
Message-ID: 1047502777.1661.553.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2003-03-12 21:03:26 Re: DELETE FROM A BLACK LIST
Previous Message mila boldareva 2003-03-12 20:49:59 Re: LEFT JOIN and missing values