listo of larde objects - Mailing list pgsql-sql

From Richard Bouska
Subject listo of larde objects
Date
Msg-id Pine.BSI.4.05L.9905111521580.1522-100000@bsdi.infima.cz
Whole thread Raw
List 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@Bouska.cz



pgsql-sql by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] plpgsql error
Next
From: Michael J Davis
Date:
Subject: RE: [SQL] plpgsql error