Deleting large object from table pg_largeobject

Поиск
Список
Период
Сортировка
От David
Тема Deleting large object from table pg_largeobject
Дата
Msg-id 1047502777.1661.553.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Deleting large object from table pg_largeobject  (Richard Huxton <dev@archonet.com>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: DELETE FROM A BLACK LIST
Следующее
От: mila boldareva
Дата:
Сообщение: Re: LEFT JOIN and missing values