Jeff,

I observe that the casts (VARCHAR ->  TEXT and TEXT ->  VARCHAR) are
marked WITHOUT FUNCTION. If that's the case, can't we use that to say
that no heap rebuild is required? Perhaps we'll need to combine this
with the typmod checks to see if we need to check the heap.

yeah, you're right .. that would give us a short list of conversions which don't require a rewrite. However, as Tom points out, that doesn't mean that they might not need a reindex (as well as OID, there's also XML).

--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to