listo of larde objects

From: Richard Bouska <xbouska(at)bsdi(dot)infima(dot)cz>
To: pgsql-sql(at)postgresql(dot)org
Subject: listo of larde objects
Date: 1999-05-11 13:28:09
Message-ID: Pine.BSI.4.05L.9905111521580.1522-100000@bsdi.infima.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello

Is there some posiibility to get a list of large objects contained in
database?

I want them for a maintanance script which will unlink the non-connected
object from db.

The trigger solution is not aplicable in my project, because I do often
the delete of whole table remembering the oid's of object in web page
form and the user can edit the oid's and if can happen that he deletes
some and I don't hawe a information which are deleted. ...

Well what I want to do is to test whether the oid's are connected in one
of two possible tables and if not I want to unlink them.

Any suggestions?

Than You in advance.
Richard Bouska
Richard(at)Bouska(dot)cz

Browse pgsql-sql by date

  From Date Subject
Next Message Michael J Davis 1999-05-11 14:23:32 RE: [SQL] plpgsql error
Previous Message Carlos Peralta Ramirez 1999-05-11 11:21:30 More problems with arrays !!!!!