From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | David <cyberguard(at)sympatico(dot)ca>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Deleting large object from table pg_largeobject |
Date: | 2003-03-14 11:02:50 |
Message-ID: | 200303141102.50176.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Carmen Sarlo | 2003-03-14 14:15:34 | Re: Poor performance on a right join |
Previous Message | Richard Huxton | 2003-03-14 10:52:02 | Re: View - Join based on dis-similar data types |