Thread

Re: [QUESTIONS] Re: [HACKERS] text should be a blob field

Peter T Mount <psqlhack@maidast.demon.co.uk> — 1998-03-06T06:56:55Z

On Thu, 5 Mar 1998, Vadim B. Mikheev wrote:

> Peter T Mount wrote:
> > 
> > On Tue, 3 Mar 1998, Bruce Momjian wrote:
> > 
> > > > make text a blob datatype (maybe storing <= 8k row with tuple, >=8k in blob
> > > > tablespace)
> > >
> > 
> > There was some talk about this about a month ago.
> > 
> > Although we now have blob support in the JDBC driver, there is one
> > outstanding issue with them, that I was waiting for 6.3 to be released
> > before starting on it (and almost certainly starting a discussion here
> > about it).
> > 
> > Allowing text to use blobs for values larger than the current block size
> > would hit the same problem.
> 
> When I told about multi-representation feature I ment that applications
> will not be affected by how text field is stored - in tuple or somewhere 
> else. Is this Ok for you ?

Yes. What I was meaning was if the "somewhere else" is in a blob, then we
would have to keep track of it if the tuple is updated or deleted.

-- 
Peter T Mount  petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk