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