Re: TOAST (was: BLOB)

From: wieck(at)debis(dot)com (Jan Wieck)
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jan Wieck <wieck(at)debis(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: TOAST (was: BLOB)
Date: 2000-04-22 20:44:52
Message-ID: m12j6lo-0003knC@orion.SAPserv.Hamburg.dsh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> wieck(at)debis(dot)com (Jan Wieck) writes:
> >> Net result for user-defined-datatype authors will be "if you revise
> >> your routines, they will be easier to read, more portable, and will
> >> support TOASTed values. If you don't, they'll still work about as
> >> well (or poorly) as they did before."
>
> > Sorry, but that ain't true. Making an existing type toastable
> > means that all functions, receiving that type need to be
> > revised.
>
> What I meant was that they'd still work, with a limit on field size,
> just like before. ie, no TOAST support.

Yes, but at the first time, a toasted value is handed to them
the result (up to backend crash) is unpredictable. So any
user defined function taking "text" as argument is
potentially in danger!

Better tell them they have to revise.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-04-22 23:09:21 Re: TOAST (was: BLOB)
Previous Message Tom Lane 2000-04-22 17:12:36 Re: TOAST (was: BLOB)