Re: Deleting large object from table pg_largeobject - Mailing list pgsql-sql

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