delete unused loid

From: Edoardo Ceccarelli <eddy(at)axa(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: delete unused loid
Date: 2004-04-06 23:10:01
Message-ID: 407338C9.1090603@axa.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Is there a way to access the pg_catalog.pg_largeobject table to delete
unused large oid's ?
I've tried with a simple

delete from pg_largeobject where loid = x

but it says that my user is not allowed... currently I'm not connecting
to the db as postgres user.

Thank you
Edoardo

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-04-06 23:17:20 Re: Have some problem about the SSL connection by JDBC
Previous Message Edoardo Ceccarelli 2004-04-06 20:54:12 Re: Visual tools