Re: [HACKERS] type coerce problem with lztext

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> Bruce Momjian writes:
>
> > Added to Features:
> >
> >  New lztext data type for compressed text fields
>
> I strongly suggest to not name this new feature. All the attempts to make
> it go away silently in 7.1 will get a blow in the face from this.

    I already discovered that this ain't true.

    At  the  time we feature TOAST, we remove LZTEXT and put in a
    type alias to TEXT. This way, during  a  dump/reload  upgrade
    from any non-toasted to a toasted release, the "backend" will
    take care for the silent conversion of table schemas. We  can
    keep  this  alias  for  a faily long time, so external schema
    scripts can be modified.

    This way, all we have to mention is  exactly  the  above,  so
    schema writers take it onto their upgrade-checklist, and that
    no application query should ever use LZTEXT explicitly  (like
    in casting expressions). They shall use TEXT instead.


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) #