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(at)debis(dot)com (Jan Wieck) #