Re: update on TOAST status'

Philip Warner wrote:
> At 14:38 11/07/00 +0200, Jan Wieck wrote:
> >> Can I suggest that we also put out a warning when defining an index using a
> >> field with a (potentially) unlimited size? Indexing a text field will
> >> mostly be a bizarre thing to do, but, eg, indexing the first 255 chars of a
> >> text field (via substr) might not be.
> >
> > Marking it BOLD somewhere in the release notes, the CREATE
> > INDEX doc and some other places should be enough. Such a
> > message at every CREATE INDEX is annoying.
>
> The suggestion was only if the index contained a text, lztext etc field,
> but no problem. The way I read your suggestion was that I'd get a real
> error when doing an insert if the text was too large.

Yes, that's what I'm after. It's too fragile IMHO to check on
multi column indices with char(n) or so if resulting index
tuples will fit in the future.

The atttypmod field on NUMERIC columns for example doesn't
tell the easy way how big the internal representation might
grow. And what about variable size user defined types that
are marked toastable? Can you estimate the maximum internal
storage size for them?

Jan

--

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