Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group