Re: TOAST (was: BLOB)

Поиск
Список
Период
Сортировка
От wieck@debis.com (Jan Wieck)
Тема Re: TOAST (was: BLOB)
Дата
Msg-id m12j6lo-0003knC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на Re: TOAST (was: BLOB)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: TOAST (was: BLOB)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> wieck@debis.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@debis.com (Jan Wieck) #




В списке pgsql-sql по дате отправления:

Предыдущее
От: jpyuyg@myhome.net
Дата:
Сообщение: GIRL & PONY 789
Следующее
От: Tom Lane
Дата:
Сообщение: Re: TOAST (was: BLOB)