вам это что-то говорит? как такое же сделать для фряхи?в-общем решено. надо было добавить СИСТЕМНУЮ локаль для сообщений en_US
(/usr/share/locales/install-lamguage-pack en_US для debian)

Модератор: terminus
вам это что-то говорит? как такое же сделать для фряхи?в-общем решено. надо было добавить СИСТЕМНУЮ локаль для сообщений en_US
(/usr/share/locales/install-lamguage-pack en_US для debian)
Код: Выделить всё
cat /etc/login.conf
...
# For postgres
pgsql:\
:lang=ru_RU.UTF-8:\
:setenv=LC_ALL=ru_RU.UTF-8:\
:tc=default:
...
Код: Выделить всё
cat /usr/local/pgsql/.shrc
...
setenv LANG ru_RU.UTF-8
setenv LC_CTYPE ru_RU.UTF-8
setenv LC_COLLATE ru_RU.UTF-8
setenv LC_TIME ru_RU.UTF-8
setenv LC_NUMERIC ru_RU.UTF-8
setenv LC_MONETARY ru_RU.UTF-8
setenv LC_MESSAGES ru_RU.UTF-8
setenv LC_ALL ru_RU.UTF-8
setenv PGDATA /usr/local/pgsql/data
...
Код: Выделить всё
setenv LANG ru_RU.UTF-8
setenv LC_CTYPE ru_RU.UTF-8
setenv LC_COLLATE ru_RU.UTF-8
setenv LC_TIME ru_RU.UTF-8
setenv LC_NUMERIC ru_RU.UTF-8
setenv LC_MONETARY ru_RU.UTF-8
setenv LC_MESSAGES ru_RU.UTF-8
setenv LC_ALL ru_RU.UTF-8
Код: Выделить всё
Aug 22 10:24:01 fileserver postgres[56634]: [3-1] ERROR: пҐп?п?п?яM-^@пҐп?п? пЇпҐп?яM-^Gп?пҐп?п? пЄп?яM-^O п©п?яM-^@п?п?п?яM-^BяM-^@п? "lc_messages": "en_US"
Aug 22 10:24:01 fileserver postgres[56634]: [3-2] пM-^ZпM-^^пM-^\пM-^PпM-^]пM-^TпM-^P: SET lc_messages to 'en_US';
Aug 22 10:24:01 fileserver postgres[56634]: [4-1] WARNING: пҐп?яM-^B яM-^BяM-^@п?пҐпЇп?п?яM-^Fп?п? п? п©яM-^@п?яM-^Fп?яM-^AяM-^Aп? п?яM-^Kп©п?п?пҐп?пҐп?яM-^O
Код: Выделить всё
[f0s@fileserver] /usr/local/pgsql/> su pgsql
%locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_ALL=en_US.UTF-8
%
Код: Выделить всё
Aug 22 10:34:01 fileserver postgres[56720]: [3-1] ERROR: invalid value for parameter "lc_messages": "en_US"
Aug 22 10:34:01 fileserver postgres[56720]: [3-2] STATEMENT: SET lc_messages to 'en_US';
Aug 22 10:34:01 fileserver postgres[56720]: [4-1] WARNING: there is no transaction in progress
Код: Выделить всё
ln -s /usr/share/locale/en_US.UTF-8 /usr/share/locale/en_US
Код: Выделить всё
Aug 22 10:37:27 fileserver postgres[56738]: [3-1] NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters
Aug 22 10:37:27 fileserver postgres[56738]: [4-1] WARNING: nonstandard use of \' in a string literal at character 97
Aug 22 10:37:27 fileserver postgres[56738]: [4-2] HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
Aug 22 10:37:27 fileserver postgres[56738]: [5-1] WARNING: nonstandard use of escape in a string literal at character 1811
Aug 22 10:37:27 fileserver postgres[56738]: [5-2] HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
Aug 22 10:37:27 fileserver postgres[56738]: [6-1] WARNING: nonstandard use of \\ in a string literal at character 17
Aug 22 10:37:27 fileserver postgres[56738]: [6-2] HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Aug 22 10:37:27 fileserver postgres[56738]: [6-3] QUERY: SELECT $1 || '\\000'
Aug 22 10:37:27 fileserver postgres[56738]: [6-4] CONTEXT: SQL statement in PL/PgSQL function "btrim" near line 10
Aug 22 10:37:27 fileserver postgres[56738]: [7-1] WARNING: nonstandard use of \\ in a string literal at character 18
Aug 22 10:37:27 fileserver postgres[56738]: [7-2] HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Aug 22 10:37:27 fileserver postgres[56738]: [7-3] QUERY: SELECT SET_BYTE('\\000\\000\\000\\000\\000\\000\\000\\000'::bytea, 4, MOD( $1 / 16777216, 256))
Aug 22 10:37:27 fileserver postgres[56738]: [7-4] CONTEXT: SQL statement in PL/PgSQL function "binrowver" near line 4
Aug 22 10:37:27 fileserver postgres[56738]: [8-1] NOTICE: type "mchar" is not yet defined
Aug 22 10:37:27 fileserver postgres[56738]: [8-2] DETAIL: Creating a shell type definition.
Aug 22 10:37:27 fileserver postgres[56738]: [9-1] ERROR: could not access file "$libdir/mchar": No such file or directory
Aug 22 10:37:27 fileserver postgres[56738]: [9-2] STATEMENT: CREATE FUNCTION mchar_in(cstring)
Aug 22 10:37:27 fileserver postgres[56738]: [9-3] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-4] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-5] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-6]
Aug 22 10:37:27 fileserver postgres[56738]: [9-7] CREATE FUNCTION mchar_out(mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-8] RETURNS cstring
Aug 22 10:37:27 fileserver postgres[56738]: [9-9] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-10] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-11]
Aug 22 10:37:27 fileserver postgres[56738]: [9-12] CREATE FUNCTION mchar_send(mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-13] RETURNS bytea
Aug 22 10:37:27 fileserver postgres[56738]: [9-14] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-15] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-16]
Aug 22 10:37:27 fileserver postgres[56738]: [9-17] CREATE FUNCTION mchar_recv(internal)
Aug 22 10:37:27 fileserver postgres[56738]: [9-18] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-19] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-20] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-21]
Aug 22 10:37:27 fileserver postgres[56738]: [9-22] CREATE TYPE mchar (
Aug 22 10:37:27 fileserver postgres[56738]: [9-23] INTERNALLENGTH = -1,
Aug 22 10:37:27 fileserver postgres[56738]: [9-24] INPUT = mchar_in,
Aug 22 10:37:27 fileserver postgres[56738]: [9-25] OUTPUT = mchar_out,
Aug 22 10:37:27 fileserver postgres[56738]: [9-26] RECEIVE = mchar_recv,
Aug 22 10:37:27 fileserver postgres[56738]: [9-27] SEND = mchar_send,
Aug 22 10:37:27 fileserver postgres[56738]: [9-28] STORAGE = extended
Aug 22 10:37:27 fileserver postgres[56738]: [9-29] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-30]
Aug 22 10:37:27 fileserver postgres[56738]: [9-31] CREATE FUNCTION mchar(mchar, integer, boolean)
Aug 22 10:37:27 fileserver postgres[56738]: [9-32] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-33] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-34] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-35]
Aug 22 10:37:27 fileserver postgres[56738]: [9-36] CREATE CAST (mchar as mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-37] WITH FUNCTION mchar(mchar, integer, boolean) as IMPLICIT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-38]
Aug 22 10:37:27 fileserver postgres[56738]: [9-39] CREATE FUNCTION mvarchar_in(cstring)
Aug 22 10:37:27 fileserver postgres[56738]: [9-40] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-41] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-42] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-43]
Aug 22 10:37:27 fileserver postgres[56738]: [9-44] CREATE FUNCTION mvarchar_out(mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-45] RETURNS cstring
Aug 22 10:37:27 fileserver postgres[56738]: [9-46] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-47] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-48]
Aug 22 10:37:27 fileserver postgres[56738]: [9-49] CREATE FUNCTION mvarchar_send(mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-50] RETURNS bytea
Aug 22 10:37:27 fileserver postgres[56738]: [9-51] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-52] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-53]
Aug 22 10:37:27 fileserver postgres[56738]: [9-54] CREATE FUNCTION mvarchar_recv(internal)
Aug 22 10:37:27 fileserver postgres[56738]: [9-55] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-56] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-57] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-58]
Aug 22 10:37:27 fileserver postgres[56738]: [9-59] CREATE TYPE mvarchar (
Aug 22 10:37:27 fileserver postgres[56738]: [9-60] INTERNALLENGTH = -1,
Aug 22 10:37:27 fileserver postgres[56738]: [9-61] INPUT = mvarchar_in,
Aug 22 10:37:27 fileserver postgres[56738]: [9-62] OUTPUT = mvarchar_out,
Aug 22 10:37:27 fileserver postgres[56738]: [9-63] RECEIVE = mvarchar_recv,
Aug 22 10:37:27 fileserver postgres[56738]: [9-64] SEND = mvarchar_send,
Aug 22 10:37:27 fileserver postgres[56738]: [9-65] STORAGE = extended
Aug 22 10:37:27 fileserver postgres[56738]: [9-66] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-67]
Aug 22 10:37:27 fileserver postgres[56738]: [9-68] CREATE FUNCTION mvarchar(mvarchar, integer, boolean)
Aug 22 10:37:27 fileserver postgres[56738]: [9-69] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-70] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-71] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-72]
Aug 22 10:37:27 fileserver postgres[56738]: [9-73] CREATE CAST (mvarchar as mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-74] WITH FUNCTION mvarchar(mvarchar, integer, boolean) as IMPLICIT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-75]
Aug 22 10:37:27 fileserver postgres[56738]: [9-76] --Operations and functions
Aug 22 10:37:27 fileserver postgres[56738]: [9-77]
Aug 22 10:37:27 fileserver postgres[56738]: [9-78] CREATE FUNCTION length(mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-79] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-80] AS '$libdir/mchar', 'mchar_length'
Aug 22 10:37:27 fileserver postgres[56738]: [9-81] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-82]
Aug 22 10:37:27 fileserver postgres[56738]: [9-83] CREATE FUNCTION upper(mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-84] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-85] AS '$libdir/mchar', 'mchar_upper'
Aug 22 10:37:27 fileserver postgres[56738]: [9-86] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-87]
Aug 22 10:37:27 fileserver postgres[56738]: [9-88] CREATE FUNCTION lower(mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-89] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-90] AS '$libdir/mchar', 'mchar_lower'
Aug 22 10:37:27 fileserver postgres[56738]: [9-91] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-92]
Aug 22 10:37:27 fileserver postgres[56738]: [9-93] CREATE FUNCTION mchar_hash(mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-94] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-95] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-96] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-97]
Aug 22 10:37:27 fileserver postgres[56738]: [9-98] CREATE FUNCTION mchar_concat(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-99] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-100] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-101] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-102]
Aug 22 10:37:27 fileserver postgres[56738]: [9-103] CREATE OPERATOR || (
Aug 22 10:37:27 fileserver postgres[56738]: [9-104] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-105] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-106] PROCEDURE = mchar_concat
Aug 22 10:37:27 fileserver postgres[56738]: [9-107] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-108]
Aug 22 10:37:27 fileserver postgres[56738]: [9-109] CREATE FUNCTION mchar_like(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-110] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-111] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-112] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-113]
Aug 22 10:37:27 fileserver postgres[56738]: [9-114] CREATE FUNCTION mchar_notlike(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-115] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-116] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-117] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-118]
Aug 22 10:37:27 fileserver postgres[56738]: [9-119] CREATE OPERATOR ~~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-120] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-121] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-122] PROCEDURE = mchar_like,
Aug 22 10:37:27 fileserver postgres[56738]: [9-123] RESTRICT = likesel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-124] JOIN = likejoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-125] NEGATOR = '!~~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-126] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-127]
Aug 22 10:37:27 fileserver postgres[56738]: [9-128] CREATE OPERATOR !~~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-129] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-130] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-131] PROCEDURE = mchar_notlike,
Aug 22 10:37:27 fileserver postgres[56738]: [9-132] RESTRICT = nlikesel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-133] JOIN = nlikejoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-134] NEGATOR = '~~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-135] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-136]
Aug 22 10:37:27 fileserver postgres[56738]: [9-137] CREATE FUNCTION mchar_regexeq(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-138] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-139] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-140] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-141]
Aug 22 10:37:27 fileserver postgres[56738]: [9-142] CREATE FUNCTION mchar_regexne(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-143] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-144] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-145] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-146]
Aug 22 10:37:27 fileserver postgres[56738]: [9-147] CREATE OPERATOR ~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-148] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-149] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-150] PROCEDURE = mchar_regexeq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-151] RESTRICT = regexeqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-152] JOIN = regexeqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-153] NEGATOR = '!~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-154] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-155]
Aug 22 10:37:27 fileserver postgres[56738]: [9-156] CREATE OPERATOR !~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-157] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-158] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-159] PROCEDURE = mchar_regexne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-160] RESTRICT = regexnesel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-161] JOIN = regexnejoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-162] NEGATOR = '~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-163] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-164]
Aug 22 10:37:27 fileserver postgres[56738]: [9-165] CREATE FUNCTION similar_escape(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-166] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-167] AS '$libdir/mchar', 'mchar_similar_escape'
Aug 22 10:37:27 fileserver postgres[56738]: [9-168] LANGUAGE C IMMUTABLE;
Aug 22 10:37:27 fileserver postgres[56738]: [9-169]
Aug 22 10:37:27 fileserver postgres[56738]: [9-170] CREATE FUNCTION length(mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-171] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-172] AS '$libdir/mchar', 'mvarchar_length'
Aug 22 10:37:27 fileserver postgres[56738]: [9-173] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-174]
Aug 22 10:37:27 fileserver postgres[56738]: [9-175] CREATE FUNCTION upper(mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-176] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-177] AS '$libdir/mchar', 'mvarchar_upper'
Aug 22 10:37:27 fileserver postgres[56738]: [9-178] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-179]
Aug 22 10:37:27 fileserver postgres[56738]: [9-180] CREATE FUNCTION lower(mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-181] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-182] AS '$libdir/mchar', 'mvarchar_lower'
Aug 22 10:37:27 fileserver postgres[56738]: [9-183] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-184]
Aug 22 10:37:27 fileserver postgres[56738]: [9-185] CREATE FUNCTION mvarchar_hash(mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-186] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-187] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-188] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-189]
Aug 22 10:37:27 fileserver postgres[56738]: [9-190] CREATE FUNCTION mvarchar_concat(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-191] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-192] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-193] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-194]
Aug 22 10:37:27 fileserver postgres[56738]: [9-195] CREATE OPERATOR || (
Aug 22 10:37:27 fileserver postgres[56738]: [9-196] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-197] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-198] PROCEDURE = mvarchar_concat
Aug 22 10:37:27 fileserver postgres[56738]: [9-199] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-200]
Aug 22 10:37:27 fileserver postgres[56738]: [9-201] CREATE FUNCTION mvarchar_like(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-202] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-203] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-204] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-205]
Aug 22 10:37:27 fileserver postgres[56738]: [9-206] CREATE FUNCTION like_escape(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-207] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-208] AS '$libdir/mchar', 'mvarchar_like_escape'
Aug 22 10:37:27 fileserver postgres[56738]: [9-209] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-210]
Aug 22 10:37:27 fileserver postgres[56738]: [9-211] CREATE FUNCTION mvarchar_notlike(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-212] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-213] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-214] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-215]
Aug 22 10:37:27 fileserver postgres[56738]: [9-216] CREATE OPERATOR ~~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-217] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-218] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-219] PROCEDURE = mvarchar_like,
Aug 22 10:37:27 fileserver postgres[56738]: [9-220] RESTRICT = likesel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-221] JOIN = likejoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-222] NEGATOR = '!~~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-223] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-224]
Aug 22 10:37:27 fileserver postgres[56738]: [9-225] CREATE OPERATOR !~~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-226] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-227] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-228] PROCEDURE = mvarchar_notlike,
Aug 22 10:37:27 fileserver postgres[56738]: [9-229] RESTRICT = nlikesel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-230] JOIN = nlikejoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-231] NEGATOR = '~~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-232] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-233]
Aug 22 10:37:27 fileserver postgres[56738]: [9-234] CREATE FUNCTION mvarchar_regexeq(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-235] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-236] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-237] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-238]
Aug 22 10:37:27 fileserver postgres[56738]: [9-239] CREATE FUNCTION mvarchar_regexne(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-240] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-241] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-242] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-243]
Aug 22 10:37:27 fileserver postgres[56738]: [9-244] CREATE OPERATOR ~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-245] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-246] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-247] PROCEDURE = mvarchar_regexeq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-248] RESTRICT = regexeqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-249] JOIN = regexeqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-250] NEGATOR = '!~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-251] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-252]
Aug 22 10:37:27 fileserver postgres[56738]: [9-253] CREATE OPERATOR !~ (
Aug 22 10:37:27 fileserver postgres[56738]: [9-254] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-255] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-256] PROCEDURE = mvarchar_regexne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-257] RESTRICT = regexnesel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-258] JOIN = regexnejoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-259] NEGATOR = '~'
Aug 22 10:37:27 fileserver postgres[56738]: [9-260] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-261]
Aug 22 10:37:27 fileserver postgres[56738]: [9-262] CREATE FUNCTION similar_escape(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-263] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-264] AS '$libdir/mchar', 'mvarchar_similar_escape'
Aug 22 10:37:27 fileserver postgres[56738]: [9-265] LANGUAGE C IMMUTABLE;
Aug 22 10:37:27 fileserver postgres[56738]: [9-266]
Aug 22 10:37:27 fileserver postgres[56738]: [9-267] CREATE FUNCTION substr (mchar, int4)
Aug 22 10:37:27 fileserver postgres[56738]: [9-268] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-269] AS '$libdir/mchar', 'mchar_substring_no_len'
Aug 22 10:37:27 fileserver postgres[56738]: [9-270] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-271]
Aug 22 10:37:27 fileserver postgres[56738]: [9-272] CREATE FUNCTION substr (mchar, int4, int4)
Aug 22 10:37:27 fileserver postgres[56738]: [9-273] RETURNS mchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-274] AS '$libdir/mchar', 'mchar_substring'
Aug 22 10:37:27 fileserver postgres[56738]: [9-275] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-276]
Aug 22 10:37:27 fileserver postgres[56738]: [9-277] CREATE FUNCTION substr (mvarchar, int4)
Aug 22 10:37:27 fileserver postgres[56738]: [9-278] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-279] AS '$libdir/mchar', 'mvarchar_substring_no_len'
Aug 22 10:37:27 fileserver postgres[56738]: [9-280] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-281]
Aug 22 10:37:27 fileserver postgres[56738]: [9-282] CREATE FUNCTION substr (mvarchar, int4, int4)
Aug 22 10:37:27 fileserver postgres[56738]: [9-283] RETURNS mvarchar
Aug 22 10:37:27 fileserver postgres[56738]: [9-284] AS '$libdir/mchar', 'mvarchar_substring'
Aug 22 10:37:27 fileserver postgres[56738]: [9-285] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-286]
Aug 22 10:37:27 fileserver postgres[56738]: [9-287] -- Comparing
Aug 22 10:37:27 fileserver postgres[56738]: [9-288] -- MCHAR
Aug 22 10:37:27 fileserver postgres[56738]: [9-289]
Aug 22 10:37:27 fileserver postgres[56738]: [9-290] CREATE FUNCTION mchar_icase_cmp(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-291] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-292] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-293] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-294]
Aug 22 10:37:27 fileserver postgres[56738]: [9-295] CREATE FUNCTION mchar_icase_eq(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-296] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-297] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-298] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-299]
Aug 22 10:37:27 fileserver postgres[56738]: [9-300] CREATE FUNCTION mchar_icase_ne(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-301] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-302] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-303] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-304]
Aug 22 10:37:27 fileserver postgres[56738]: [9-305] CREATE FUNCTION mchar_icase_lt(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-306] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-307] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-308] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-309]
Aug 22 10:37:27 fileserver postgres[56738]: [9-310] CREATE FUNCTION mchar_icase_le(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-311] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-312] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-313] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-314]
Aug 22 10:37:27 fileserver postgres[56738]: [9-315] CREATE FUNCTION mchar_icase_gt(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-316] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-317] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-318] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-319]
Aug 22 10:37:27 fileserver postgres[56738]: [9-320] CREATE FUNCTION mchar_icase_ge(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-321] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-322] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-323] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-324]
Aug 22 10:37:27 fileserver postgres[56738]: [9-325]
Aug 22 10:37:27 fileserver postgres[56738]: [9-326] CREATE OPERATOR < (
Aug 22 10:37:27 fileserver postgres[56738]: [9-327] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-328] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-329] PROCEDURE = mchar_icase_lt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-330] COMMUTATOR = '>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-331] NEGATOR = '>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-332] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-333] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-334] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-335]
Aug 22 10:37:27 fileserver postgres[56738]: [9-336] CREATE OPERATOR > (
Aug 22 10:37:27 fileserver postgres[56738]: [9-337] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-338] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-339] PROCEDURE = mchar_icase_gt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-340] COMMUTATOR = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-341] NEGATOR = '<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-342] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-343] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-344] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-345]
Aug 22 10:37:27 fileserver postgres[56738]: [9-346] CREATE OPERATOR <= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-347] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-348] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-349] PROCEDURE = mchar_icase_le,
Aug 22 10:37:27 fileserver postgres[56738]: [9-350] COMMUTATOR = '>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-351] NEGATOR = '>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-352] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-353] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-354] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-355]
Aug 22 10:37:27 fileserver postgres[56738]: [9-356] CREATE OPERATOR >= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-357] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-358] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-359] PROCEDURE = mchar_icase_ge,
Aug 22 10:37:27 fileserver postgres[56738]: [9-360] COMMUTATOR = '<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-361] NEGATOR = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-362] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-363] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-364] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-365]
Aug 22 10:37:27 fileserver postgres[56738]: [9-366] CREATE OPERATOR = (
Aug 22 10:37:27 fileserver postgres[56738]: [9-367] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-368] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-369] PROCEDURE = mchar_icase_eq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-370] COMMUTATOR = '=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-371] NEGATOR = '<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-372] RESTRICT = eqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-373] JOIN = eqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-374] SORT1 = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-375] SORT2 = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-376] HASHES
Aug 22 10:37:27 fileserver postgres[56738]: [9-377] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-378]
Aug 22 10:37:27 fileserver postgres[56738]: [9-379] CREATE OPERATOR <> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-380] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-381] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-382] PROCEDURE = mchar_icase_ne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-383] COMMUTATOR = '<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-384] NEGATOR = '=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-385] RESTRICT = neqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-386] JOIN = neqjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-387] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-388]
Aug 22 10:37:27 fileserver postgres[56738]: [9-389] CREATE FUNCTION mchar_case_cmp(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-390] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-391] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-392] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-393]
Aug 22 10:37:27 fileserver postgres[56738]: [9-394] CREATE FUNCTION mchar_case_eq(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-395] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-396] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-397] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-398]
Aug 22 10:37:27 fileserver postgres[56738]: [9-399] CREATE FUNCTION mchar_case_ne(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-400] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-401] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-402] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-403]
Aug 22 10:37:27 fileserver postgres[56738]: [9-404] CREATE FUNCTION mchar_case_lt(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-405] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-406] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-407] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-408]
Aug 22 10:37:27 fileserver postgres[56738]: [9-409] CREATE FUNCTION mchar_case_le(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-410] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-411] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-412] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-413]
Aug 22 10:37:27 fileserver postgres[56738]: [9-414] CREATE FUNCTION mchar_case_gt(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-415] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-416] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-417] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-418]
Aug 22 10:37:27 fileserver postgres[56738]: [9-419] CREATE FUNCTION mchar_case_ge(mchar, mchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-420] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-421] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-422] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-423]
Aug 22 10:37:27 fileserver postgres[56738]: [9-424]
Aug 22 10:37:27 fileserver postgres[56738]: [9-425] CREATE OPERATOR &< (
Aug 22 10:37:27 fileserver postgres[56738]: [9-426] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-427] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-428] PROCEDURE = mchar_case_lt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-429] COMMUTATOR = '&>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-430] NEGATOR = '&>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-431] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-432] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-433] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-434]
Aug 22 10:37:27 fileserver postgres[56738]: [9-435] CREATE OPERATOR &> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-436] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-437] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-438] PROCEDURE = mchar_case_gt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-439] COMMUTATOR = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-440] NEGATOR = '&<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-441] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-442] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-443] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-444]
Aug 22 10:37:27 fileserver postgres[56738]: [9-445] CREATE OPERATOR &<= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-446] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-447] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-448] PROCEDURE = mchar_case_le,
Aug 22 10:37:27 fileserver postgres[56738]: [9-449] COMMUTATOR = '&>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-450] NEGATOR = '&>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-451] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-452] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-453] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-454]
Aug 22 10:37:27 fileserver postgres[56738]: [9-455] CREATE OPERATOR &>= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-456] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-457] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-458] PROCEDURE = mchar_case_ge,
Aug 22 10:37:27 fileserver postgres[56738]: [9-459] COMMUTATOR = '&<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-460] NEGATOR = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-461] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-462] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-463] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-464]
Aug 22 10:37:27 fileserver postgres[56738]: [9-465] CREATE OPERATOR &= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-466] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-467] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-468] PROCEDURE = mchar_case_eq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-469] COMMUTATOR = '&=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-470] NEGATOR = '&<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-471] RESTRICT = eqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-472] JOIN = eqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-473] SORT1 = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-474] SORT2 = '&<'
Aug 22 10:37:27 fileserver postgres[56738]: [9-475] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-476]
Aug 22 10:37:27 fileserver postgres[56738]: [9-477] CREATE OPERATOR &<> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-478] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-479] RIGHTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-480] PROCEDURE = mchar_case_ne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-481] COMMUTATOR = '&<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-482] NEGATOR = '&=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-483] RESTRICT = neqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-484] JOIN = neqjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-485] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-486]
Aug 22 10:37:27 fileserver postgres[56738]: [9-487] --MVARCHAR
Aug 22 10:37:27 fileserver postgres[56738]: [9-488]
Aug 22 10:37:27 fileserver postgres[56738]: [9-489] CREATE FUNCTION mvarchar_icase_cmp(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-490] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-491] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-492] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-493]
Aug 22 10:37:27 fileserver postgres[56738]: [9-494] CREATE FUNCTION mvarchar_icase_eq(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-495] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-496] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-497] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-498]
Aug 22 10:37:27 fileserver postgres[56738]: [9-499] CREATE FUNCTION mvarchar_icase_ne(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-500] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-501] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-502] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-503]
Aug 22 10:37:27 fileserver postgres[56738]: [9-504] CREATE FUNCTION mvarchar_icase_lt(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-505] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-506] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-507] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-508]
Aug 22 10:37:27 fileserver postgres[56738]: [9-509] CREATE FUNCTION mvarchar_icase_le(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-510] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-511] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-512] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-513]
Aug 22 10:37:27 fileserver postgres[56738]: [9-514] CREATE FUNCTION mvarchar_icase_gt(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-515] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-516] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-517] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-518]
Aug 22 10:37:27 fileserver postgres[56738]: [9-519] CREATE FUNCTION mvarchar_icase_ge(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-520] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-521] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-522] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-523]
Aug 22 10:37:27 fileserver postgres[56738]: [9-524]
Aug 22 10:37:27 fileserver postgres[56738]: [9-525] CREATE OPERATOR < (
Aug 22 10:37:27 fileserver postgres[56738]: [9-526] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-527] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-528] PROCEDURE = mvarchar_icase_lt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-529] COMMUTATOR = '>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-530] NEGATOR = '>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-531] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-532] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-533] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-534]
Aug 22 10:37:27 fileserver postgres[56738]: [9-535] CREATE OPERATOR > (
Aug 22 10:37:27 fileserver postgres[56738]: [9-536] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-537] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-538] PROCEDURE = mvarchar_icase_gt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-539] COMMUTATOR = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-540] NEGATOR = '<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-541] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-542] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-543] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-544]
Aug 22 10:37:27 fileserver postgres[56738]: [9-545] CREATE OPERATOR <= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-546] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-547] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-548] PROCEDURE = mvarchar_icase_le,
Aug 22 10:37:27 fileserver postgres[56738]: [9-549] COMMUTATOR = '>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-550] NEGATOR = '>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-551] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-552] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-553] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-554]
Aug 22 10:37:27 fileserver postgres[56738]: [9-555] CREATE OPERATOR >= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-556] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-557] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-558] PROCEDURE = mvarchar_icase_ge,
Aug 22 10:37:27 fileserver postgres[56738]: [9-559] COMMUTATOR = '<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-560] NEGATOR = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-561] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-562] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-563] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-564]
Aug 22 10:37:27 fileserver postgres[56738]: [9-565] CREATE OPERATOR = (
Aug 22 10:37:27 fileserver postgres[56738]: [9-566] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-567] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-568] PROCEDURE = mvarchar_icase_eq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-569] COMMUTATOR = '=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-570] NEGATOR = '<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-571] RESTRICT = eqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-572] JOIN = eqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-573] SORT1 = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-574] SORT2 = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-575] HASHES
Aug 22 10:37:27 fileserver postgres[56738]: [9-576] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-577]
Aug 22 10:37:27 fileserver postgres[56738]: [9-578] CREATE OPERATOR <> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-579] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-580] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-581] PROCEDURE = mvarchar_icase_ne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-582] COMMUTATOR = '<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-583] NEGATOR = '=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-584] RESTRICT = neqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-585] JOIN = neqjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-586] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-587]
Aug 22 10:37:27 fileserver postgres[56738]: [9-588] CREATE FUNCTION mvarchar_case_cmp(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-589] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-590] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-591] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-592]
Aug 22 10:37:27 fileserver postgres[56738]: [9-593] CREATE FUNCTION mvarchar_case_eq(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-594] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-595] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-596] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-597]
Aug 22 10:37:27 fileserver postgres[56738]: [9-598] CREATE FUNCTION mvarchar_case_ne(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-599] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-600] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-601] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-602]
Aug 22 10:37:27 fileserver postgres[56738]: [9-603] CREATE FUNCTION mvarchar_case_lt(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-604] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-605] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-606] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-607]
Aug 22 10:37:27 fileserver postgres[56738]: [9-608] CREATE FUNCTION mvarchar_case_le(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-609] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-610] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-611] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-612]
Aug 22 10:37:27 fileserver postgres[56738]: [9-613] CREATE FUNCTION mvarchar_case_gt(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-614] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-615] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-616] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-617]
Aug 22 10:37:27 fileserver postgres[56738]: [9-618] CREATE FUNCTION mvarchar_case_ge(mvarchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-619] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-620] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-621] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-622]
Aug 22 10:37:27 fileserver postgres[56738]: [9-623]
Aug 22 10:37:27 fileserver postgres[56738]: [9-624] CREATE OPERATOR &< (
Aug 22 10:37:27 fileserver postgres[56738]: [9-625] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-626] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-627] PROCEDURE = mvarchar_case_lt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-628] COMMUTATOR = '&>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-629] NEGATOR = '&>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-630] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-631] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-632] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-633]
Aug 22 10:37:27 fileserver postgres[56738]: [9-634] CREATE OPERATOR &> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-635] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-636] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-637] PROCEDURE = mvarchar_case_gt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-638] COMMUTATOR = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-639] NEGATOR = '&<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-640] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-641] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-642] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-643]
Aug 22 10:37:27 fileserver postgres[56738]: [9-644] CREATE OPERATOR &<= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-645] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-646] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-647] PROCEDURE = mvarchar_case_le,
Aug 22 10:37:27 fileserver postgres[56738]: [9-648] COMMUTATOR = '&>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-649] NEGATOR = '&>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-650] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-651] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-652] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-653]
Aug 22 10:37:27 fileserver postgres[56738]: [9-654] CREATE OPERATOR &>= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-655] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-656] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-657] PROCEDURE = mvarchar_case_ge,
Aug 22 10:37:27 fileserver postgres[56738]: [9-658] COMMUTATOR = '&<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-659] NEGATOR = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-660] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-661] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-662] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-663]
Aug 22 10:37:27 fileserver postgres[56738]: [9-664] CREATE OPERATOR &= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-665] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-666] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-667] PROCEDURE = mvarchar_case_eq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-668] COMMUTATOR = '&=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-669] NEGATOR = '&<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-670] RESTRICT = eqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-671] JOIN = eqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-672] SORT1 = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-673] SORT2 = '&<'
Aug 22 10:37:27 fileserver postgres[56738]: [9-674] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-675]
Aug 22 10:37:27 fileserver postgres[56738]: [9-676] CREATE OPERATOR &<> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-677] LEFTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-678] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-679] PROCEDURE = mvarchar_case_ne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-680] COMMUTATOR = '&<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-681] NEGATOR = '&=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-682] RESTRICT = neqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-683] JOIN = neqjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-684] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-685]
Aug 22 10:37:27 fileserver postgres[56738]: [9-686] -- MCHAR <> MVARCHAR
Aug 22 10:37:27 fileserver postgres[56738]: [9-687]
Aug 22 10:37:27 fileserver postgres[56738]: [9-688] CREATE FUNCTION mc_mv_icase_cmp(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-689] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-690] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-691] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-692]
Aug 22 10:37:27 fileserver postgres[56738]: [9-693] CREATE FUNCTION mc_mv_icase_eq(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-694] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-695] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-696] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-697]
Aug 22 10:37:27 fileserver postgres[56738]: [9-698] CREATE FUNCTION mc_mv_icase_ne(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-699] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-700] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-701] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-702]
Aug 22 10:37:27 fileserver postgres[56738]: [9-703] CREATE FUNCTION mc_mv_icase_lt(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-704] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-705] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-706] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-707]
Aug 22 10:37:27 fileserver postgres[56738]: [9-708] CREATE FUNCTION mc_mv_icase_le(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-709] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-710] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-711] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-712]
Aug 22 10:37:27 fileserver postgres[56738]: [9-713] CREATE FUNCTION mc_mv_icase_gt(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-714] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-715] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-716] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-717]
Aug 22 10:37:27 fileserver postgres[56738]: [9-718] CREATE FUNCTION mc_mv_icase_ge(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-719] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-720] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-721] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-722]
Aug 22 10:37:27 fileserver postgres[56738]: [9-723]
Aug 22 10:37:27 fileserver postgres[56738]: [9-724] CREATE OPERATOR < (
Aug 22 10:37:27 fileserver postgres[56738]: [9-725] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-726] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-727] PROCEDURE = mc_mv_icase_lt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-728] COMMUTATOR = '>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-729] NEGATOR = '>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-730] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-731] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-732] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-733]
Aug 22 10:37:27 fileserver postgres[56738]: [9-734] CREATE OPERATOR > (
Aug 22 10:37:27 fileserver postgres[56738]: [9-735] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-736] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-737] PROCEDURE = mc_mv_icase_gt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-738] COMMUTATOR = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-739] NEGATOR = '<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-740] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-741] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-742] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-743]
Aug 22 10:37:27 fileserver postgres[56738]: [9-744] CREATE OPERATOR <= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-745] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-746] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-747] PROCEDURE = mc_mv_icase_le,
Aug 22 10:37:27 fileserver postgres[56738]: [9-748] COMMUTATOR = '>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-749] NEGATOR = '>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-750] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-751] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-752] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-753]
Aug 22 10:37:27 fileserver postgres[56738]: [9-754] CREATE OPERATOR >= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-755] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-756] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-757] PROCEDURE = mc_mv_icase_ge,
Aug 22 10:37:27 fileserver postgres[56738]: [9-758] COMMUTATOR = '<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-759] NEGATOR = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-760] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-761] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-762] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-763]
Aug 22 10:37:27 fileserver postgres[56738]: [9-764] CREATE OPERATOR = (
Aug 22 10:37:27 fileserver postgres[56738]: [9-765] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-766] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-767] PROCEDURE = mc_mv_icase_eq,
Aug 22 10:37:27 fileserver postgres[56738]: [9-768] COMMUTATOR = '=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-769] NEGATOR = '<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-770] RESTRICT = eqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-771] JOIN = eqjoinsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-772] SORT1 = '<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-773] SORT2 = '<'
Aug 22 10:37:27 fileserver postgres[56738]: [9-774] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-775]
Aug 22 10:37:27 fileserver postgres[56738]: [9-776] CREATE OPERATOR <> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-777] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-778] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-779] PROCEDURE = mc_mv_icase_ne,
Aug 22 10:37:27 fileserver postgres[56738]: [9-780] COMMUTATOR = '<>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-781] NEGATOR = '=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-782] RESTRICT = neqsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-783] JOIN = neqjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-784] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-785]
Aug 22 10:37:27 fileserver postgres[56738]: [9-786] CREATE FUNCTION mc_mv_case_cmp(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-787] RETURNS int4
Aug 22 10:37:27 fileserver postgres[56738]: [9-788] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-789] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-790]
Aug 22 10:37:27 fileserver postgres[56738]: [9-791] CREATE FUNCTION mc_mv_case_eq(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-792] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-793] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-794] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-795]
Aug 22 10:37:27 fileserver postgres[56738]: [9-796] CREATE FUNCTION mc_mv_case_ne(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-797] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-798] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-799] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-800]
Aug 22 10:37:27 fileserver postgres[56738]: [9-801] CREATE FUNCTION mc_mv_case_lt(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-802] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-803] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-804] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-805]
Aug 22 10:37:27 fileserver postgres[56738]: [9-806] CREATE FUNCTION mc_mv_case_le(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-807] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-808] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-809] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-810]
Aug 22 10:37:27 fileserver postgres[56738]: [9-811] CREATE FUNCTION mc_mv_case_gt(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-812] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-813] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-814] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-815]
Aug 22 10:37:27 fileserver postgres[56738]: [9-816] CREATE FUNCTION mc_mv_case_ge(mchar, mvarchar)
Aug 22 10:37:27 fileserver postgres[56738]: [9-817] RETURNS bool
Aug 22 10:37:27 fileserver postgres[56738]: [9-818] AS '$libdir/mchar'
Aug 22 10:37:27 fileserver postgres[56738]: [9-819] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:27 fileserver postgres[56738]: [9-820]
Aug 22 10:37:27 fileserver postgres[56738]: [9-821]
Aug 22 10:37:27 fileserver postgres[56738]: [9-822] CREATE OPERATOR &< (
Aug 22 10:37:27 fileserver postgres[56738]: [9-823] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-824] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-825] PROCEDURE = mc_mv_case_lt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-826] COMMUTATOR = '&>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-827] NEGATOR = '&>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-828] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-829] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-830] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-831]
Aug 22 10:37:27 fileserver postgres[56738]: [9-832] CREATE OPERATOR &> (
Aug 22 10:37:27 fileserver postgres[56738]: [9-833] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-834] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-835] PROCEDURE = mc_mv_case_gt,
Aug 22 10:37:27 fileserver postgres[56738]: [9-836] COMMUTATOR = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-837] NEGATOR = '&<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-838] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-839] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-840] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-841]
Aug 22 10:37:27 fileserver postgres[56738]: [9-842] CREATE OPERATOR &<= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-843] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-844] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-845] PROCEDURE = mc_mv_case_le,
Aug 22 10:37:27 fileserver postgres[56738]: [9-846] COMMUTATOR = '&>=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-847] NEGATOR = '&>',
Aug 22 10:37:27 fileserver postgres[56738]: [9-848] RESTRICT = scalarltsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-849] JOIN = scalarltjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-850] );
Aug 22 10:37:27 fileserver postgres[56738]: [9-851]
Aug 22 10:37:27 fileserver postgres[56738]: [9-852] CREATE OPERATOR &>= (
Aug 22 10:37:27 fileserver postgres[56738]: [9-853] LEFTARG = mchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-854] RIGHTARG = mvarchar,
Aug 22 10:37:27 fileserver postgres[56738]: [9-855] PROCEDURE = mc_mv_case_ge,
Aug 22 10:37:27 fileserver postgres[56738]: [9-856] COMMUTATOR = '&<=',
Aug 22 10:37:27 fileserver postgres[56738]: [9-857] NEGATOR = '&<',
Aug 22 10:37:27 fileserver postgres[56738]: [9-858] RESTRICT = scalargtsel,
Aug 22 10:37:27 fileserver postgres[56738]: [9-859] JOIN = scalargtjoinsel
Aug 22 10:37:27 fileserver postgres[56738]: [9-860] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-861]
Aug 22 10:37:28 fileserver postgres[56738]: [9-862] CREATE OPERATOR &= (
Aug 22 10:37:28 fileserver postgres[56738]: [9-863] LEFTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-864] RIGHTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-865] PROCEDURE = mc_mv_case_eq,
Aug 22 10:37:28 fileserver postgres[56738]: [9-866] COMMUTATOR = '&=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-867] NEGATOR = '&<>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-868] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-869] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-870] SORT1 = '&<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-871] SORT2 = '&<'
Aug 22 10:37:28 fileserver postgres[56738]: [9-872] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-873]
Aug 22 10:37:28 fileserver postgres[56738]: [9-874] CREATE OPERATOR &<> (
Aug 22 10:37:28 fileserver postgres[56738]: [9-875] LEFTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-876] RIGHTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-877] PROCEDURE = mc_mv_case_ne,
Aug 22 10:37:28 fileserver postgres[56738]: [9-878] COMMUTATOR = '&<>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-879] NEGATOR = '&=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-880] RESTRICT = neqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-881] JOIN = neqjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-882] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-883]
Aug 22 10:37:28 fileserver postgres[56738]: [9-884] -- MVARCHAR <> MCHAR
Aug 22 10:37:28 fileserver postgres[56738]: [9-885]
Aug 22 10:37:28 fileserver postgres[56738]: [9-886] CREATE FUNCTION mv_mc_icase_cmp(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-887] RETURNS int4
Aug 22 10:37:28 fileserver postgres[56738]: [9-888] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-889] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-890]
Aug 22 10:37:28 fileserver postgres[56738]: [9-891] CREATE FUNCTION mv_mc_icase_eq(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-892] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-893] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-894] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-895]
Aug 22 10:37:28 fileserver postgres[56738]: [9-896] CREATE FUNCTION mv_mc_icase_ne(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-897] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-898] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-899] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-900]
Aug 22 10:37:28 fileserver postgres[56738]: [9-901] CREATE FUNCTION mv_mc_icase_lt(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-902] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-903] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-904] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-905]
Aug 22 10:37:28 fileserver postgres[56738]: [9-906] CREATE FUNCTION mv_mc_icase_le(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-907] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-908] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-909] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-910]
Aug 22 10:37:28 fileserver postgres[56738]: [9-911] CREATE FUNCTION mv_mc_icase_gt(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-912] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-913] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-914] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-915]
Aug 22 10:37:28 fileserver postgres[56738]: [9-916] CREATE FUNCTION mv_mc_icase_ge(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-917] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-918] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-919] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-920]
Aug 22 10:37:28 fileserver postgres[56738]: [9-921]
Aug 22 10:37:28 fileserver postgres[56738]: [9-922] CREATE OPERATOR < (
Aug 22 10:37:28 fileserver postgres[56738]: [9-923] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-924] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-925] PROCEDURE = mv_mc_icase_lt,
Aug 22 10:37:28 fileserver postgres[56738]: [9-926] COMMUTATOR = '>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-927] NEGATOR = '>=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-928] RESTRICT = scalarltsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-929] JOIN = scalarltjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-930] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-931]
Aug 22 10:37:28 fileserver postgres[56738]: [9-932] CREATE OPERATOR > (
Aug 22 10:37:28 fileserver postgres[56738]: [9-933] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-934] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-935] PROCEDURE = mv_mc_icase_gt,
Aug 22 10:37:28 fileserver postgres[56738]: [9-936] COMMUTATOR = '<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-937] NEGATOR = '<=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-938] RESTRICT = scalargtsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-939] JOIN = scalargtjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-940] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-941]
Aug 22 10:37:28 fileserver postgres[56738]: [9-942] CREATE OPERATOR <= (
Aug 22 10:37:28 fileserver postgres[56738]: [9-943] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-944] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-945] PROCEDURE = mv_mc_icase_le,
Aug 22 10:37:28 fileserver postgres[56738]: [9-946] COMMUTATOR = '>=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-947] NEGATOR = '>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-948] RESTRICT = scalarltsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-949] JOIN = scalarltjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-950] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-951]
Aug 22 10:37:28 fileserver postgres[56738]: [9-952] CREATE OPERATOR >= (
Aug 22 10:37:28 fileserver postgres[56738]: [9-953] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-954] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-955] PROCEDURE = mv_mc_icase_ge,
Aug 22 10:37:28 fileserver postgres[56738]: [9-956] COMMUTATOR = '<=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-957] NEGATOR = '<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-958] RESTRICT = scalargtsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-959] JOIN = scalargtjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-960] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-961]
Aug 22 10:37:28 fileserver postgres[56738]: [9-962] CREATE OPERATOR = (
Aug 22 10:37:28 fileserver postgres[56738]: [9-963] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-964] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-965] PROCEDURE = mv_mc_icase_eq,
Aug 22 10:37:28 fileserver postgres[56738]: [9-966] COMMUTATOR = '=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-967] NEGATOR = '<>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-968] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-969] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-970] SORT1 = '<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-971] SORT2 = '<'
Aug 22 10:37:28 fileserver postgres[56738]: [9-972] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-973]
Aug 22 10:37:28 fileserver postgres[56738]: [9-974] CREATE OPERATOR <> (
Aug 22 10:37:28 fileserver postgres[56738]: [9-975] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-976] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-977] PROCEDURE = mv_mc_icase_ne,
Aug 22 10:37:28 fileserver postgres[56738]: [9-978] COMMUTATOR = '<>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-979] NEGATOR = '=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-980] RESTRICT = neqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-981] JOIN = neqjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-982] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-983]
Aug 22 10:37:28 fileserver postgres[56738]: [9-984] CREATE FUNCTION mv_mc_case_cmp(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-985] RETURNS int4
Aug 22 10:37:28 fileserver postgres[56738]: [9-986] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-987] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-988]
Aug 22 10:37:28 fileserver postgres[56738]: [9-989] CREATE FUNCTION mv_mc_case_eq(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-990] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-991] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-992] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-993]
Aug 22 10:37:28 fileserver postgres[56738]: [9-994] CREATE FUNCTION mv_mc_case_ne(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-995] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-996] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-997] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-998]
Aug 22 10:37:28 fileserver postgres[56738]: [9-999] CREATE FUNCTION mv_mc_case_lt(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1000] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-1001] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1002] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1003]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1004] CREATE FUNCTION mv_mc_case_le(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1005] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-1006] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1007] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1008]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1009] CREATE FUNCTION mv_mc_case_gt(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1010] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-1011] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1012] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1013]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1014] CREATE FUNCTION mv_mc_case_ge(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1015] RETURNS bool
Aug 22 10:37:28 fileserver postgres[56738]: [9-1016] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1017] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1018]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1019]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1020] CREATE OPERATOR &< (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1021] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1022] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1023] PROCEDURE = mv_mc_case_lt,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1024] COMMUTATOR = '&>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1025] NEGATOR = '&>=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1026] RESTRICT = scalarltsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1027] JOIN = scalarltjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-1028] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1029]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1030] CREATE OPERATOR &> (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1031] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1032] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1033] PROCEDURE = mv_mc_case_gt,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1034] COMMUTATOR = '&<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1035] NEGATOR = '&<=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1036] RESTRICT = scalargtsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1037] JOIN = scalargtjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-1038] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1039]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1040] CREATE OPERATOR &<= (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1041] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1042] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1043] PROCEDURE = mv_mc_case_le,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1044] COMMUTATOR = '&>=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1045] NEGATOR = '&>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1046] RESTRICT = scalarltsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1047] JOIN = scalarltjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-1048] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1049]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1050] CREATE OPERATOR &>= (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1051] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1052] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1053] PROCEDURE = mv_mc_case_ge,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1054] COMMUTATOR = '&<=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1055] NEGATOR = '&<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1056] RESTRICT = scalargtsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1057] JOIN = scalargtjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-1058] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1059]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1060] CREATE OPERATOR &= (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1061] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1062] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1063] PROCEDURE = mv_mc_case_eq,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1064] COMMUTATOR = '&=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1065] NEGATOR = '&<>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1066] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1067] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1068] SORT1 = '&<',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1069] SORT2 = '&<'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1070] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1071]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1072] CREATE OPERATOR &<> (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1073] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1074] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1075] PROCEDURE = mv_mc_case_ne,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1076] COMMUTATOR = '&<>',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1077] NEGATOR = '&=',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1078] RESTRICT = neqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1079] JOIN = neqjoinsel
Aug 22 10:37:28 fileserver postgres[56738]: [9-1080] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1081]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1082] -- MCHAR - VARCHAR operations
Aug 22 10:37:28 fileserver postgres[56738]: [9-1083]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1084] CREATE FUNCTION mchar_mvarchar_concat(mchar, mvarchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1085] RETURNS mvarchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1086] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1087] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1088]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1089] CREATE OPERATOR || (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1090] LEFTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1091] RIGHTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1092] PROCEDURE = mchar_mvarchar_concat
Aug 22 10:37:28 fileserver postgres[56738]: [9-1093] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1094]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1095] CREATE FUNCTION mvarchar_mchar_concat(mvarchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1096] RETURNS mvarchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1097] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1098] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1099]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1100] CREATE OPERATOR || (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1101] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1102] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1103] PROCEDURE = mvarchar_mchar_concat
Aug 22 10:37:28 fileserver postgres[56738]: [9-1104] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1105]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1106] CREATE FUNCTION mvarchar_mchar(mvarchar, integer, boolean)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1107] RETURNS mchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1108] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1109] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1110]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1111] CREATE CAST (mvarchar as mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1112] WITH FUNCTION mvarchar_mchar(mvarchar, integer, boolean) as IMPLICIT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1113]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1114] CREATE FUNCTION mchar_mvarchar(mchar, integer, boolean)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1115] RETURNS mvarchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1116] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1117] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1118]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1119] CREATE CAST (mchar as mvarchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1120] WITH FUNCTION mchar_mvarchar(mchar, integer, boolean) as IMPLICIT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1121]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1122] -- Aggregates
Aug 22 10:37:28 fileserver postgres[56738]: [9-1123]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1124] CREATE FUNCTION mchar_larger(mchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1125] RETURNS mchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1126] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1127] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1128]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1129] CREATE AGGREGATE max (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1130] BASETYPE = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1131] SFUNC = mchar_larger,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1132] STYPE = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1133] SORTOP = '>'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1134] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1135]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1136] CREATE FUNCTION mchar_smaller(mchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1137] RETURNS mchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1138] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1139] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1140]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1141] CREATE AGGREGATE min (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1142] BASETYPE = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1143] SFUNC = mchar_smaller,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1144] STYPE = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1145] SORTOP = '<'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1146] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1147]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1148] CREATE FUNCTION mvarchar_larger(mvarchar, mvarchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1149] RETURNS mvarchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1150] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1151] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1152]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1153] CREATE AGGREGATE max (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1154] BASETYPE = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1155] SFUNC = mvarchar_larger,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1156] STYPE = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1157] SORTOP = '>'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1158] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1159]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1160] CREATE FUNCTION mvarchar_smaller(mvarchar, mvarchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1161] RETURNS mvarchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1162] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1163] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1164]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1165] CREATE AGGREGATE min (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1166] BASETYPE = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1167] SFUNC = mvarchar_smaller,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1168] STYPE = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1169] SORTOP = '<'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1170] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1171]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1172] -- B-tree support
Aug 22 10:37:28 fileserver postgres[56738]: [9-1173]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1174] CREATE OPERATOR CLASS mchar_icase_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1175] DEFAULT FOR TYPE mchar USING btree AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1176] OPERATOR 1 < ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1177] OPERATOR 2 <= ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1178] OPERATOR 3 = ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1179] OPERATOR 4 >= ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1180] OPERATOR 5 > ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1181] FUNCTION 1 mchar_icase_cmp(mchar, mchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1182] OPERATOR 1 < (mchar, mvarchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1183] OPERATOR 2 <= (mchar, mvarchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1184] OPERATOR 3 = (mchar, mvarchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1185] OPERATOR 4 >= (mchar, mvarchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1186] OPERATOR 5 > (mchar, mvarchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1187] FUNCTION 1 mc_mv_icase_cmp(mchar, mvarchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1188]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1189] CREATE OPERATOR CLASS mchar_icase_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1190] DEFAULT FOR TYPE mchar USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1191] OPERATOR 1 = ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1192] FUNCTION 1 mchar_hash(mchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1193]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1194] CREATE OPERATOR CLASS mvarchar_icase_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1195] DEFAULT FOR TYPE mvarchar USING btree AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1196] OPERATOR 1 < ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1197] OPERATOR 2 <= ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1198] OPERATOR 3 = ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1199] OPERATOR 4 >= ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1200] OPERATOR 5 > ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1201] FUNCTION 1 mvarchar_icase_cmp(mvarchar, mvarchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1202] OPERATOR 1 < (mvarchar, mchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1203] OPERATOR 2 <= (mvarchar, mchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1204] OPERATOR 3 = (mvarchar, mchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1205] OPERATOR 4 >= (mvarchar, mchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1206] OPERATOR 5 > (mvarchar, mchar),
Aug 22 10:37:28 fileserver postgres[56738]: [9-1207] FUNCTION 1 mv_mc_icase_cmp(mvarchar, mchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1208]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1209] CREATE OPERATOR CLASS mvarchar_icase_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1210] DEFAULT FOR TYPE mvarchar USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1211] OPERATOR 1 = ,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1212] FUNCTION 1 mvarchar_hash(mvarchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1213]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1214]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1215] -- Index support for LIKE
Aug 22 10:37:28 fileserver postgres[56738]: [9-1216]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1217] CREATE FUNCTION mchar_pattern_fixed_prefix(internal, internal, internal, internal)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1218] RETURNS int4
Aug 22 10:37:28 fileserver postgres[56738]: [9-1219] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1220] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1221]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1222] CREATE FUNCTION mchar_greaterstring(internal)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1223] RETURNS internal
Aug 22 10:37:28 fileserver postgres[56738]: [9-1224] AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1225] LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1226] --
Aug 22 10:37:28 fileserver postgres[56738]: [9-1227] --
Aug 22 10:37:28 fileserver postgres[56738]: [9-1228] -- FULLEQ
Aug 22 10:37:28 fileserver postgres[56738]: [9-1229] --
Aug 22 10:37:28 fileserver postgres[56738]: [9-1230] --
Aug 22 10:37:28 fileserver postgres[56738]: [9-1231] CREATE OR REPLACE FUNCTION isfulleq_bool(bool, bool)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1232] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1233] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1234]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1235] CREATE OR REPLACE FUNCTION fullhash_bool(bool)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1236] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1237] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1238]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1239]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1240] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1241] LEFTARG = bool,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1242] RIGHTARG = bool,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1243] PROCEDURE = isfulleq_bool,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1244] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1245] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1246] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1247] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1248] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1249]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1250] CREATE OPERATOR CLASS bool_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1251] FOR TYPE bool USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1252] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1253] FUNCTION 1 fullhash_bool(bool);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1254]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1255] -- For bytea
Aug 22 10:37:28 fileserver postgres[56738]: [9-1256]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1257] CREATE OR REPLACE FUNCTION isfulleq_bytea(bytea, bytea)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1258] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1259] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1260]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1261] CREATE OR REPLACE FUNCTION fullhash_bytea(bytea)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1262] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1263] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1264]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1265]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1266] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1267] LEFTARG = bytea,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1268] RIGHTARG = bytea,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1269] PROCEDURE = isfulleq_bytea,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1270] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1271] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1272] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1273] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1274] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1275]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1276] CREATE OPERATOR CLASS bytea_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1277] FOR TYPE bytea USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1278] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1279] FUNCTION 1 fullhash_bytea(bytea);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1280]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1281] -- For char
Aug 22 10:37:28 fileserver postgres[56738]: [9-1282]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1283] CREATE OR REPLACE FUNCTION isfulleq_char(char, char)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1284] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1285] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1286]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1287] CREATE OR REPLACE FUNCTION fullhash_char(char)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1288] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1289] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1290]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1291]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1292] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1293] LEFTARG = char,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1294] RIGHTARG = char,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1295] PROCEDURE = isfulleq_char,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1296] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1297] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1298] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1299] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1300] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1301]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1302] CREATE OPERATOR CLASS char_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1303] FOR TYPE char USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1304] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1305] FUNCTION 1 fullhash_char(char);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1306]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1307] -- For name
Aug 22 10:37:28 fileserver postgres[56738]: [9-1308]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1309] CREATE OR REPLACE FUNCTION isfulleq_name(name, name)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1310] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1311] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1312]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1313] CREATE OR REPLACE FUNCTION fullhash_name(name)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1314] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1315] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1316]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1317]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1318] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1319] LEFTARG = name,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1320] RIGHTARG = name,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1321] PROCEDURE = isfulleq_name,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1322] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1323] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1324] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1325] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1326] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1327]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1328] CREATE OPERATOR CLASS name_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1329] FOR TYPE name USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1330] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1331] FUNCTION 1 fullhash_name(name);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1332]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1333] -- For int8
Aug 22 10:37:28 fileserver postgres[56738]: [9-1334]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1335] CREATE OR REPLACE FUNCTION isfulleq_int8(int8, int8)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1336] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1337] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1338]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1339] CREATE OR REPLACE FUNCTION fullhash_int8(int8)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1340] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1341] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1342]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1343]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1344] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1345] LEFTARG = int8,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1346] RIGHTARG = int8,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1347] PROCEDURE = isfulleq_int8,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1348] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1349] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1350] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1351] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1352] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1353]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1354] CREATE OPERATOR CLASS int8_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1355] FOR TYPE int8 USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1356] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1357] FUNCTION 1 fullhash_int8(int8);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1358]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1359] -- For int2
Aug 22 10:37:28 fileserver postgres[56738]: [9-1360]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1361] CREATE OR REPLACE FUNCTION isfulleq_int2(int2, int2)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1362] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1363] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1364]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1365] CREATE OR REPLACE FUNCTION fullhash_int2(int2)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1366] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1367] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1368]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1369]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1370] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1371] LEFTARG = int2,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1372] RIGHTARG = int2,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1373] PROCEDURE = isfulleq_int2,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1374] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1375] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1376] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1377] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1378] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1379]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1380] CREATE OPERATOR CLASS int2_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1381] FOR TYPE int2 USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1382] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1383] FUNCTION 1 fullhash_int2(int2);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1384]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1385] -- For int2vector
Aug 22 10:37:28 fileserver postgres[56738]: [9-1386]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1387] CREATE OR REPLACE FUNCTION isfulleq_int2vector(int2vector, int2vector)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1388] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1389] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1390]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1391] CREATE OR REPLACE FUNCTION fullhash_int2vector(int2vector)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1392] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1393] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1394]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1395]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1396] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1397] LEFTARG = int2vector,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1398] RIGHTARG = int2vector,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1399] PROCEDURE = isfulleq_int2vector,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1400] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1401] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1402] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1403] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1404] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1405]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1406] CREATE OPERATOR CLASS int2vector_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1407] FOR TYPE int2vector USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1408] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1409] FUNCTION 1 fullhash_int2vector(int2vector);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1410]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1411] -- For int4
Aug 22 10:37:28 fileserver postgres[56738]: [9-1412]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1413] CREATE OR REPLACE FUNCTION isfulleq_int4(int4, int4)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1414] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1415] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1416]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1417] CREATE OR REPLACE FUNCTION fullhash_int4(int4)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1418] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1419] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1420]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1421]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1422] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1423] LEFTARG = int4,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1424] RIGHTARG = int4,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1425] PROCEDURE = isfulleq_int4,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1426] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1427] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1428] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1429] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1430] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1431]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1432] CREATE OPERATOR CLASS int4_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1433] FOR TYPE int4 USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1434] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1435] FUNCTION 1 fullhash_int4(int4);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1436]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1437] -- For text
Aug 22 10:37:28 fileserver postgres[56738]: [9-1438]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1439] CREATE OR REPLACE FUNCTION isfulleq_text(text, text)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1440] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1441] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1442]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1443] CREATE OR REPLACE FUNCTION fullhash_text(text)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1444] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1445] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1446]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1447]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1448] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1449] LEFTARG = text,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1450] RIGHTARG = text,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1451] PROCEDURE = isfulleq_text,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1452] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1453] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1454] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1455] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1456] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1457]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1458] CREATE OPERATOR CLASS text_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1459] FOR TYPE text USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1460] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1461] FUNCTION 1 fullhash_text(text);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1462]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1463] -- For oid
Aug 22 10:37:28 fileserver postgres[56738]: [9-1464]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1465] CREATE OR REPLACE FUNCTION isfulleq_oid(oid, oid)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1466] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1467] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1468]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1469] CREATE OR REPLACE FUNCTION fullhash_oid(oid)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1470] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1471] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1472]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1473]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1474] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1475] LEFTARG = oid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1476] RIGHTARG = oid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1477] PROCEDURE = isfulleq_oid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1478] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1479] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1480] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1481] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1482] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1483]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1484] CREATE OPERATOR CLASS oid_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1485] FOR TYPE oid USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1486] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1487] FUNCTION 1 fullhash_oid(oid);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1488]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1489] -- For xid
Aug 22 10:37:28 fileserver postgres[56738]: [9-1490]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1491] CREATE OR REPLACE FUNCTION isfulleq_xid(xid, xid)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1492] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1493] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1494]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1495] CREATE OR REPLACE FUNCTION fullhash_xid(xid)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1496] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1497] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1498]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1499]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1500] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1501] LEFTARG = xid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1502] RIGHTARG = xid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1503] PROCEDURE = isfulleq_xid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1504] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1505] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1506] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1507] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1508] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1509]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1510] CREATE OPERATOR CLASS xid_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1511] FOR TYPE xid USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1512] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1513] FUNCTION 1 fullhash_xid(xid);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1514]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1515] -- For cid
Aug 22 10:37:28 fileserver postgres[56738]: [9-1516]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1517] CREATE OR REPLACE FUNCTION isfulleq_cid(cid, cid)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1518] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1519] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1520]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1521] CREATE OR REPLACE FUNCTION fullhash_cid(cid)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1522] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1523] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1524]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1525]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1526] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1527] LEFTARG = cid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1528] RIGHTARG = cid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1529] PROCEDURE = isfulleq_cid,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1530] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1531] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1532] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1533] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1534] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1535]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1536] CREATE OPERATOR CLASS cid_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1537] FOR TYPE cid USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1538] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1539] FUNCTION 1 fullhash_cid(cid);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1540]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1541] -- For oidvector
Aug 22 10:37:28 fileserver postgres[56738]: [9-1542]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1543] CREATE OR REPLACE FUNCTION isfulleq_oidvector(oidvector, oidvector)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1544] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1545] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1546]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1547] CREATE OR REPLACE FUNCTION fullhash_oidvector(oidvector)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1548] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1549] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1550]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1551]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1552] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1553] LEFTARG = oidvector,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1554] RIGHTARG = oidvector,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1555] PROCEDURE = isfulleq_oidvector,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1556] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1557] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1558] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1559] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1560] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1561]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1562] CREATE OPERATOR CLASS oidvector_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1563] FOR TYPE oidvector USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1564] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1565] FUNCTION 1 fullhash_oidvector(oidvector);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1566]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1567] -- For float4
Aug 22 10:37:28 fileserver postgres[56738]: [9-1568]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1569] CREATE OR REPLACE FUNCTION isfulleq_float4(float4, float4)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1570] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1571] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1572]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1573] CREATE OR REPLACE FUNCTION fullhash_float4(float4)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1574] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1575] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1576]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1577]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1578] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1579] LEFTARG = float4,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1580] RIGHTARG = float4,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1581] PROCEDURE = isfulleq_float4,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1582] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1583] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1584] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1585] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1586] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1587]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1588] CREATE OPERATOR CLASS float4_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1589] FOR TYPE float4 USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1590] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1591] FUNCTION 1 fullhash_float4(float4);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1592]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1593] -- For float8
Aug 22 10:37:28 fileserver postgres[56738]: [9-1594]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1595] CREATE OR REPLACE FUNCTION isfulleq_float8(float8, float8)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1596] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1597] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1598]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1599] CREATE OR REPLACE FUNCTION fullhash_float8(float8)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1600] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1601] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1602]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1603]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1604] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1605] LEFTARG = float8,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1606] RIGHTARG = float8,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1607] PROCEDURE = isfulleq_float8,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1608] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1609] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1610] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1611] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1612] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1613]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1614] CREATE OPERATOR CLASS float8_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1615] FOR TYPE float8 USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1616] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1617] FUNCTION 1 fullhash_float8(float8);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1618]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1619] -- For abstime
Aug 22 10:37:28 fileserver postgres[56738]: [9-1620]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1621] CREATE OR REPLACE FUNCTION isfulleq_abstime(abstime, abstime)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1622] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1623] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1624]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1625] CREATE OR REPLACE FUNCTION fullhash_abstime(abstime)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1626] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1627] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1628]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1629]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1630] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1631] LEFTARG = abstime,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1632] RIGHTARG = abstime,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1633] PROCEDURE = isfulleq_abstime,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1634] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1635] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1636] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1637] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1638] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1639]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1640] CREATE OPERATOR CLASS abstime_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1641] FOR TYPE abstime USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1642] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1643] FUNCTION 1 fullhash_abstime(abstime);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1644]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1645] -- For reltime
Aug 22 10:37:28 fileserver postgres[56738]: [9-1646]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1647] CREATE OR REPLACE FUNCTION isfulleq_reltime(reltime, reltime)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1648] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1649] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1650]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1651] CREATE OR REPLACE FUNCTION fullhash_reltime(reltime)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1652] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1653] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1654]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1655]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1656] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1657] LEFTARG = reltime,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1658] RIGHTARG = reltime,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1659] PROCEDURE = isfulleq_reltime,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1660] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1661] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1662] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1663] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1664] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1665]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1666] CREATE OPERATOR CLASS reltime_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1667] FOR TYPE reltime USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1668] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1669] FUNCTION 1 fullhash_reltime(reltime);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1670]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1671] -- For macaddr
Aug 22 10:37:28 fileserver postgres[56738]: [9-1672]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1673] CREATE OR REPLACE FUNCTION isfulleq_macaddr(macaddr, macaddr)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1674] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1675] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1676]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1677] CREATE OR REPLACE FUNCTION fullhash_macaddr(macaddr)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1678] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1679] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1680]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1681]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1682] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1683] LEFTARG = macaddr,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1684] RIGHTARG = macaddr,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1685] PROCEDURE = isfulleq_macaddr,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1686] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1687] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1688] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1689] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1690] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1691]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1692] CREATE OPERATOR CLASS macaddr_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1693] FOR TYPE macaddr USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1694] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1695] FUNCTION 1 fullhash_macaddr(macaddr);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1696]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1697] -- For inet
Aug 22 10:37:28 fileserver postgres[56738]: [9-1698]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1699] CREATE OR REPLACE FUNCTION isfulleq_inet(inet, inet)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1700] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1701] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1702]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1703] CREATE OR REPLACE FUNCTION fullhash_inet(inet)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1704] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1705] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1706]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1707]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1708] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1709] LEFTARG = inet,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1710] RIGHTARG = inet,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1711] PROCEDURE = isfulleq_inet,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1712] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1713] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1714] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1715] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1716] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1717]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1718] CREATE OPERATOR CLASS inet_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1719] FOR TYPE inet USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1720] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1721] FUNCTION 1 fullhash_inet(inet);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1722]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1723] -- For cidr
Aug 22 10:37:28 fileserver postgres[56738]: [9-1724]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1725] CREATE OR REPLACE FUNCTION isfulleq_cidr(cidr, cidr)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1726] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1727] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1728]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1729] CREATE OR REPLACE FUNCTION fullhash_cidr(cidr)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1730] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1731] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1732]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1733]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1734] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1735] LEFTARG = cidr,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1736] RIGHTARG = cidr,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1737] PROCEDURE = isfulleq_cidr,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1738] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1739] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1740] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1741] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1742] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1743]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1744] CREATE OPERATOR CLASS cidr_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1745] FOR TYPE cidr USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1746] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1747] FUNCTION 1 fullhash_cidr(cidr);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1748]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1749] -- For varchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1750]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1751] CREATE OR REPLACE FUNCTION isfulleq_varchar(varchar, varchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1752] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1753] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1754]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1755] CREATE OR REPLACE FUNCTION fullhash_varchar(varchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1756] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1757] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1758]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1759]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1760] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1761] LEFTARG = varchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1762] RIGHTARG = varchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1763] PROCEDURE = isfulleq_varchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1764] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1765] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1766] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1767] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1768] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1769]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1770] CREATE OPERATOR CLASS varchar_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1771] FOR TYPE varchar USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1772] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1773] FUNCTION 1 fullhash_varchar(varchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1774]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1775] -- For date
Aug 22 10:37:28 fileserver postgres[56738]: [9-1776]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1777] CREATE OR REPLACE FUNCTION isfulleq_date(date, date)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1778] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1779] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1780]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1781] CREATE OR REPLACE FUNCTION fullhash_date(date)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1782] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1783] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1784]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1785]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1786] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1787] LEFTARG = date,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1788] RIGHTARG = date,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1789] PROCEDURE = isfulleq_date,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1790] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1791] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1792] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1793] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1794] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1795]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1796] CREATE OPERATOR CLASS date_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1797] FOR TYPE date USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1798] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1799] FUNCTION 1 fullhash_date(date);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1800]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1801] -- For time
Aug 22 10:37:28 fileserver postgres[56738]: [9-1802]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1803] CREATE OR REPLACE FUNCTION isfulleq_time(time, time)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1804] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1805] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1806]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1807] CREATE OR REPLACE FUNCTION fullhash_time(time)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1808] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1809] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1810]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1811]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1812] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1813] LEFTARG = time,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1814] RIGHTARG = time,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1815] PROCEDURE = isfulleq_time,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1816] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1817] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1818] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1819] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1820] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1821]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1822] CREATE OPERATOR CLASS time_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1823] FOR TYPE time USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1824] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1825] FUNCTION 1 fullhash_time(time);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1826]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1827] -- For timestamp
Aug 22 10:37:28 fileserver postgres[56738]: [9-1828]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1829] CREATE OR REPLACE FUNCTION isfulleq_timestamp(timestamp, timestamp)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1830] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1831] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1832]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1833] CREATE OR REPLACE FUNCTION fullhash_timestamp(timestamp)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1834] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1835] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1836]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1837]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1838] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1839] LEFTARG = timestamp,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1840] RIGHTARG = timestamp,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1841] PROCEDURE = isfulleq_timestamp,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1842] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1843] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1844] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1845] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1846] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1847]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1848] CREATE OPERATOR CLASS timestamp_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1849] FOR TYPE timestamp USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1850] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1851] FUNCTION 1 fullhash_timestamp(timestamp);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1852]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1853] -- For timestamptz
Aug 22 10:37:28 fileserver postgres[56738]: [9-1854]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1855] CREATE OR REPLACE FUNCTION isfulleq_timestamptz(timestamptz, timestamptz)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1856] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1857] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1858]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1859] CREATE OR REPLACE FUNCTION fullhash_timestamptz(timestamptz)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1860] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1861] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1862]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1863]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1864] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1865] LEFTARG = timestamptz,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1866] RIGHTARG = timestamptz,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1867] PROCEDURE = isfulleq_timestamptz,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1868] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1869] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1870] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1871] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1872] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1873]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1874] CREATE OPERATOR CLASS timestamptz_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1875] FOR TYPE timestamptz USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1876] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1877] FUNCTION 1 fullhash_timestamptz(timestamptz);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1878]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1879] -- For interval
Aug 22 10:37:28 fileserver postgres[56738]: [9-1880]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1881] CREATE OR REPLACE FUNCTION isfulleq_interval(interval, interval)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1882] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1883] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1884]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1885] CREATE OR REPLACE FUNCTION fullhash_interval(interval)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1886] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1887] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1888]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1889]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1890] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1891] LEFTARG = interval,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1892] RIGHTARG = interval,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1893] PROCEDURE = isfulleq_interval,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1894] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1895] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1896] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1897] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1898] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1899]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1900] CREATE OPERATOR CLASS interval_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1901] FOR TYPE interval USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1902] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1903] FUNCTION 1 fullhash_interval(interval);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1904]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1905] -- For timetz
Aug 22 10:37:28 fileserver postgres[56738]: [9-1906]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1907] CREATE OR REPLACE FUNCTION isfulleq_timetz(timetz, timetz)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1908] RETURNS bool AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1909] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1910]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1911] CREATE OR REPLACE FUNCTION fullhash_timetz(timetz)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1912] RETURNS int4 AS '$libdir/fulleq'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1913] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1914]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1915]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1916] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1917] LEFTARG = timetz,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1918] RIGHTARG = timetz,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1919] PROCEDURE = isfulleq_timetz,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1920] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1921] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1922] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1923] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1924] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1925]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1926] CREATE OPERATOR CLASS timetz_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1927] FOR TYPE timetz USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1928] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1929] FUNCTION 1 fullhash_timetz(timetz);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1930]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1931] -- For mchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1932]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1933] CREATE OR REPLACE FUNCTION isfulleq_mchar(mchar, mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1934] RETURNS bool AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1935] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1936]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1937] CREATE OR REPLACE FUNCTION fullhash_mchar(mchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1938] RETURNS int4 AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1939] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1940]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1941] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1942] LEFTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1943] RIGHTARG = mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1944] PROCEDURE = isfulleq_mchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1945] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1946] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1947] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1948] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1949] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1950]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1951] CREATE OPERATOR CLASS mchar_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1952] FOR TYPE mchar USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1953] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1954] FUNCTION 1 fullhash_mchar(mchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1955]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1956] -- For mvarchar
Aug 22 10:37:28 fileserver postgres[56738]: [9-1957]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1958] CREATE OR REPLACE FUNCTION isfulleq_mvarchar(mvarchar, mvarchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1959] RETURNS bool AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1960] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1961]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1962] CREATE OR REPLACE FUNCTION fullhash_mvarchar(mvarchar)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1963] RETURNS int4 AS '$libdir/mchar'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1964] LANGUAGE C CALLED ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1965]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1966] CREATE OPERATOR == (
Aug 22 10:37:28 fileserver postgres[56738]: [9-1967] LEFTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1968] RIGHTARG = mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1969] PROCEDURE = isfulleq_mvarchar,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1970] COMMUTATOR = '==',
Aug 22 10:37:28 fileserver postgres[56738]: [9-1971] RESTRICT = eqsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1972] JOIN = eqjoinsel,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1973] HASHES
Aug 22 10:37:28 fileserver postgres[56738]: [9-1974] );
Aug 22 10:37:28 fileserver postgres[56738]: [9-1975]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1976] CREATE OPERATOR CLASS mvarchar_fill_ops
Aug 22 10:37:28 fileserver postgres[56738]: [9-1977] FOR TYPE mvarchar USING hash AS
Aug 22 10:37:28 fileserver postgres[56738]: [9-1978] OPERATOR 1 ==,
Aug 22 10:37:28 fileserver postgres[56738]: [9-1979] FUNCTION 1 fullhash_mvarchar(mvarchar);
Aug 22 10:37:28 fileserver postgres[56738]: [9-1980]
Aug 22 10:37:28 fileserver postgres[56738]: [9-1981] CREATE OR REPLACE FUNCTION fasttruncate(text)
Aug 22 10:37:28 fileserver postgres[56738]: [9-1982] RETURNS void AS '$libdir/fasttrun'
Aug 22 10:37:28 fileserver postgres[56738]: [9-1983] LANGUAGE C RETURNS NULL ON NULL INPUT IMMUTABLE;
Aug 22 10:37:28 fileserver postgres[56738]: [9-1984]
Aug 22 10:37:28 fileserver postgres[56738]: [10-1] WARNING: there is no transaction in progress