Thread: pgsql: Fixes from Janko Richter - Fix wrong
Log Message:
-----------
Fixes from Janko Richter <jankorichter@yahoo.de>
- Fix wrong index results on text, char, varchar for multibyte strings
- Fix some SIGFPE signals
- Add support for infinite timestamps
- Because of locale settings, btree_gist can not be a prefix index anymore (for text).
Each node holds now just the lower and upper boundary.
Modified Files:
--------------
pgsql/contrib/btree_gist:
btree_bit.c (r1.5 -> r1.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_bit.c.diff?r1=1.5&r2=1.6)
btree_bytea.c (r1.5 -> r1.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_bytea.c.diff?r1=1.5&r2=1.6)
btree_cash.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_cash.c.diff?r1=1.3&r2=1.4)
btree_float4.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_float4.c.diff?r1=1.3&r2=1.4)
btree_float8.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_float8.c.diff?r1=1.3&r2=1.4)
btree_inet.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_inet.c.diff?r1=1.3&r2=1.4)
btree_int2.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_int2.c.diff?r1=1.3&r2=1.4)
btree_int4.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_int4.c.diff?r1=1.3&r2=1.4)
btree_int8.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_int8.c.diff?r1=1.3&r2=1.4)
btree_interval.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_interval.c.diff?r1=1.3&r2=1.4)
btree_macaddr.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_macaddr.c.diff?r1=1.3&r2=1.4)
btree_numeric.c (r1.5 -> r1.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_numeric.c.diff?r1=1.5&r2=1.6)
btree_oid.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_oid.c.diff?r1=1.3&r2=1.4)
btree_text.c (r1.6 -> r1.7)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_text.c.diff?r1=1.6&r2=1.7)
btree_ts.c (r1.9 -> r1.10)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_ts.c.diff?r1=1.9&r2=1.10)
btree_utils_num.h (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_utils_num.h.diff?r1=1.3&r2=1.4)
btree_utils_var.c (r1.9 -> r1.10)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_utils_var.c.diff?r1=1.9&r2=1.10)
btree_utils_var.h (r1.2 -> r1.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_utils_var.h.diff?r1=1.2&r2=1.3)
pgsql/contrib/btree_gist/data:
char.data (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/data/char.data.diff?r1=1.1&r2=1.2)
timestamp.data (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/data/timestamp.data.diff?r1=1.1&r2=1.2)
timestamptz.data (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/data/timestamptz.data.diff?r1=1.1&r2=1.2)
pgsql/contrib/btree_gist/expected:
bytea.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/expected/bytea.out.diff?r1=1.1&r2=1.2)
char.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/expected/char.out.diff?r1=1.1&r2=1.2)
text.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/expected/text.out.diff?r1=1.1&r2=1.2)
timestamp.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/expected/timestamp.out.diff?r1=1.1&r2=1.2)
timestamptz.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/expected/timestamptz.out.diff?r1=1.1&r2=1.2)
varchar.out (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/expected/varchar.out.diff?r1=1.1&r2=1.2)