BLOBs

From: Dustin Sallings <dustin(at)spy(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: BLOBs
Date: 1998-07-24 04:55:54
Message-ID: ML-3.5-SPY.901256154.5627.dustin@bleu.west.spy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


Hey, I never saw a follow-up on any of the BLOB questions, so I thought
I'd throw them in here again:

Is there a way to actually *delete* a BLOB?

Is anyone working on BLOBs?

Last time I tried to use it, it seemed to store each BLOB in a file by
itself (two files?) in the middle of my data directory, which seems like a very
bad thing IMO. I also couldn't find any documented way of removing them, and
simply deleting the file(s) caused my vacuum to fail. I'd really like to use
BLOBs instead of nasty MIME encoding of large images, but I'd definitely need
to be able to delete, and it'd be nice if I wouldn't fill up that one directory
with them. If nobody is working on BLOBs, it might be fun to find a way to
implement another storage mechanism, possibly a single file (group of files) to
store the BLOB, or a directory hierarchy.

TIA.

--
SA, software.net My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maarten Boekhold 1998-07-24 07:46:08 Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
Previous Message The Web Administrator 1998-07-24 04:22:17 Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

Browse pgsql-hackers by date

  From Date Subject
Next Message Brandon Ibach 1998-07-24 05:38:03 CIDR type
Previous Message The Web Administrator 1998-07-24 04:22:17 Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]