A Couple of Questions on Blobs

From: Scott Holmes <sholmes(at)pacificnet(dot)net>
To: pgsql-general(at)postgresql(dot)org (PG-General)
Subject: A Couple of Questions on Blobs
Date: 2001-05-22 22:38:32
Message-ID: 200105222238.PAA11246@scotts.mynetwork.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

First, I believe I probably have some orphan blobs in one of my databases. I
have updated some records, replacing one image oid with another before I knew
about lo_unlink. Is there a method for finding such stranded objects?

My second question concerns updating existing blobs in a database. I've been
asked to create some functions for inserting word processor documents in the
database, then allowing users to fetch them and edit them. Looking at the lo_
functions provided, it seems to me I will need to lo_export(the_file); allow
the user to do what ever they want with it; lo_unlink(the_file); then update
table set doc_oid = lo_import(the_file)

Is this the correct methodology or am I missing something significant?

Thanks, Scott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2001-05-22 22:48:51 Re: Autocommit off in psql??
Previous Message Neil Conway 2001-05-22 22:26:23 Re: Cant get Perl Module loaded