Log Message:
-----------
While perusing SQL92 I realized that we are delivering the wrong SQLSTATE
error code for string-too-long errors. It should be STRING_DATA_RIGHT_TRUNCATION
not STRING_DATA_LENGTH_MISMATCH. The latter probably should only be
applied to cases where a string must be exactly so many bits --- there are
no cases at all where it applies to character strings, only bit strings.
Modified Files:
--------------
pgsql-server/src/backend/utils/adt:
varbit.c (r1.39 -> r1.40)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/varbit.c.diff?r1=1.39&r2=1.40)
varchar.c (r1.104 -> r1.105)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/varchar.c.diff?r1=1.104&r2=1.105)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
