Re: [GENERAL] Can I store bitmap graphics in a table? - Mailing list pgsql-general

From Peter T Mount
Subject Re: [GENERAL] Can I store bitmap graphics in a table?
Date
Msg-id Pine.LNX.3.96.980725140246.3383F-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: [GENERAL] Can I store bitmap graphics in a table?  (Dustin Sallings <dustin@spy.net>)
List pgsql-general
On Tue, 21 Jul 1998, Dustin Sallings wrote:

>     b) Couldn't figure out how to delete a BLOB and have it go away (since
>        you only store the reference to the BLOB).

lo_unlink deletes a blob.

>     c) They don't back up with pgdump, which isn't too bad of a problem,
>        since I don't mind making my own dump program.

I did have some code that backed up any large objects in a database into a
zip file using the JDBC interface.

hmmm, I'll see if I can dig it up and add it to the jdbc examples in the
distribution.

>     Is the BLOB interface being worked on at all?  I'd be interested in
> making my program do things a little closer to the ``right'' way.  :)  (or
> maybe playing with the BLOB interface myself).

I'm looking at blob orphaning, which I think I may have solved. Hopefully,
I'll have something working by Monday.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk


pgsql-general by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [GENERAL] BLOBs
Next
From: The Hermit Hacker
Date:
Subject: Weekly Posting: Mini-FAQ (Last Modified: Jun 7, 98)