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
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 |