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