не запускается постгре

f0s · Непрочитанное сообщение **f0s** » 2008-08-20 14:00:08

Поставил из портов postgresql82-server
версия 8.2.4

по мануалу сделал:

в /etc/rc.conf написал:

postgresql_enable="YES"
postgresql_class="postgres"

в /etc/login.conf

Код: Выделить всё

postgres:\
        :lang=ru_RU.utf-8:\
        :setenv=LC_COLLATE=C:\
        :tc=default:

далее запустил /usr/local/etc/rc.d/postgresql intdb

Код: Выделить всё

Файлы, сопутствующие этой системе баз данных, будут
принадлежать пользователю "pgsql". Этот пользователь
также должен быть владельцем процесса сервера.
Кластер баз данных будет инициализирован с локалью C.

база каталог /usr/local/pgsql/data создался.

конфиг pg_hba.conf настроил:

Код: Выделить всё

host    all         all         0.0.0.0/0             md5

конфиг posgresql.conf тоже настроил:

Код: Выделить всё

data_directory = '/usr/local/pgsql/data'
hba_file = '/usr/local/pgsql/data/pg_hba.conf'
 
listen_addresses = '*'
max_connections = 40
shared_buffers = 1MB
temp_buffers = 16MB
max_prepared_transactions = 5
work_mem = 96MB
maintenance_work_mem = 512MB
max_stack_depth = 4MB
max_fsm_pages = 179200
wal_buffers = 512kB
effective_cache_size = 1024MB
default_statistics_target = 100
log_destination = 'syslog'
log_directory = '/var/log/pgsql'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' 
log_rotation_age = 1d
log_rotation_size = 10MB
 
silent_mode = on
stats_start_collecor = on
stats_row_level = on
autovacuum = on
datestyle = 'iso, mdy'
lc_messages = 'C'			# locale for system error message 
					# strings
lc_monetary = 'C'			# locale for monetary formatting
lc_numeric = 'C'			# locale for number formatting
lc_time = 'C'				# locale for time formatting
max_locks_per_transaction = 150

при попытке запуска, он выдает что не запустилось

Код: Выделить всё

[f0s@fileserver] /usr/local/etc/rc.d/> ./postgresql start
could not start server

однако:

Код: Выделить всё

[f0s@fileserver] /usr/local/pgsql/data/> ps -axj | grep pos
pgsql     12820     1 12820 12820    0 Ss    ??    0:00,06 /usr/local/bin/postgres -D /usr/local/pgsql/data
pgsql     12822 12820 12822 12822    0 Ss    ??    0:00,00 postgres: writer process    (postgres)
pgsql     12823 12820 12823 12823    0 Ss    ??    0:00,00 postgres: stats collector process    (postgres)
root      12805 12141 12805 12137    1 S     p2    0:00,01 /bin/sh ./postgresql start
[f0s@fileserver] /usr/local/pgsql/data/>

но в /var/log/messages сыпется это:

Код: Выделить всё

Aug 20 14:42:35 fileserver postgres[12750]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:36 fileserver postgres[12751]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:37 fileserver postgres[12752]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:38 fileserver postgres[12753]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:39 fileserver postgres[12754]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:40 fileserver postgres[12755]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:41 fileserver postgres[12756]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:42 fileserver postgres[12757]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:43 fileserver postgres[12759]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off
Aug 20 14:42:44 fileserver postgres[12762]: [3-1] FATAL:  no pg_hba.conf entry for host "[local]", user "pgsql", database "postgres", SSL off

и при попытке получить доступ к базе, спрашивает пароль.. не знаю какой он...

Код: Выделить всё

[f0s@fileserver] /usr/local/pgsql/data/> psql -h localhost postgres postgres
Password for user postgres:
psql: FATAL:  password authentication failed for user "postgres"

система:

Код: Выделить всё

[f0s@fileserver] /usr/local/etc/rc.d/> uname -a
FreeBSD fileserver.artpaint 6.2-RELEASE-p8 FreeBSD 6.2-RELEASE-p8 #0: Fri Nov 16 11:36:47 MSK 2007     root@fileserver.artpaint:/usr/obj/usr/src/sys/fileserver.kern-2007-16-11  amd64

Код: Выделить всё

[f0s@fileserver] /usr/local/etc/rc.d/> pkg_info | grep postgre
postgresql-client-8.2.4 PostgreSQL database (client)
postgresql-server-8.2.4_1 The most advanced open-source database available anywhere

ps. кстати не старшно что shared_buffers всего 1МБ? у меня при больших значениях вот так ругается:

Код: Выделить всё

Aug 20 14:02:19 fileserver postgres[12172]: [1-1] FATAL:  could not create shared memory segment: Invalid argument
Aug 20 14:02:19 fileserver postgres[12172]: [1-2] DETAIL:  Failed system call was shmget(key=5432001, size=56483840, 03600).
Aug 20 14:02:19 fileserver postgres[12172]: [1-3] HINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded your
Aug 20 14:02:19 fileserver postgres[12172]: [1-4]  You can either reduce the request size or reconfigure the kernel with larger SHMMAX.  To reduce th
Aug 20 14:02:19 fileserver postgres[12172]: [1-5]  56483840 bytes), reduce PostgreSQL's shared_buffers parameter (currently 6144) and/or its max_conn
Aug 20 14:02:19 fileserver postgres[12172]: [1-6]  40).
Aug 20 14:02:19 fileserver postgres[12172]: [1-7]       If the request size is already small, it's possible that it is less than your kernel's SHMMIN
Aug 20 14:02:19 fileserver postgres[12172]: [1-8]  the request size or reconfiguring SHMMIN is called for.
Aug 20 14:02:19 fileserver postgres[12172]: [1-9]       The PostgreSQL documentation contains more information about shared memory configuration.

Хостинг HostFood.ru · **Хостинг HostFood.ru**

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

Непрочитанное сообщение **zingel** » 2008-08-20 14:02:37

патч есть от Сысоева для фряхового 7.0p-3 ядра на тему:

Код: Выделить всё

the request size or reconfiguring SHMMIN

Диффыч:

Код: Выделить всё

diff -u -r src.orig/sys/kern/sysv_shm.c src/sys/kern/sysv_shm.c
--- src.orig/sys/kern/sysv_shm.c 2008-03-13
15:26:59.000000000 +0300
+++ src/sys/kern/sysv_shm.c 2008-03-13 15:22:24.000000000 +0300
@@ -717,7 +717,8 @@
struct shmget_args *uap;
int mode;
{
- int i, segnum, shmid, size;
+ int i, segnum, shmid;
+ size_t size;
struct ucred *cred = td->td_ucred;
struct shmid_kernel *shmseg;
vm_object_t shm_object;
diff -u -r src.orig/sys/sys/shm.h src/sys/sys/shm.h
--- src.orig/sys/sys/shm.h 2008-03-13 15:26:59.000000000 +0300
+++ src/sys/sys/shm.h 2008-03-13 15:19:01.000000000 +0300
@@ -77,7 +77,7 @@

struct shmid_ds {
struct ipc_perm shm_perm; /* operation permission structure */
- int             shm_segsz; /* size of segment in bytes */
+ size_t          shm_segsz; /* size of segment in bytes */
pid_t           shm_lpid;   /* process ID of last shared
memory op */
pid_t           shm_cpid; /* process ID of creator */
short shm_nattch; /* number of current attaches */
diff -u -r src.orig/usr.bin/ipcs/ipcs.c src/usr.bin/ipcs/ipcs.c
--- src.orig/usr.bin/ipcs/ipcs.c 2008-03-13
15:26:59.000000000 +0300
+++ src/usr.bin/ipcs/ipcs.c 2008-03-13 15:26:26.000000000 +0300
@@ -376,15 +376,15 @@
if ((display & (SHMINFO | SHMTOTAL))) {
if (display & SHMTOTAL) {
printf("shminfo:\n");
- printf("\tshmmax: %12d\t(max shared memory segment size)\n",
+ printf("\tshmmax: %12ld\t(max shared memory segment
size)\n",
   shminfo.shmmax);
- printf("\tshmmin: %12d\t(min shared memory segment size)\n",
+ printf("\tshmmin: %12ld\t(min shared memory segment
size)\n",
   shminfo.shmmin);
- printf("\tshmmni: %12d\t(max number of shared memory
identifiers)\n",
+ printf("\tshmmni: %12ld\t(max number of shared memory
identifiers)\n",
   shminfo.shmmni);
- printf("\tshmseg: %12d\t(max shared memory segments per
process)\n",
+ printf("\tshmseg: %12ld\t(max shared memory segments per
process)\n",
   shminfo.shmseg);
- printf("\tshmall: %12d\t(max amount of shared memory in
pages)\n\n",
+ printf("\tshmall: %12ld\t(max amount of shared memory in
pages)\n\n",
   shminfo.shmall);
}
if (display & SHMINFO) {

f0s · Непрочитанное сообщение **f0s** » 2008-08-20 14:17:54

эм.. ты сейчас с кем разговаривал?

у меня 6.2 версия..

а поповоду сабжа, из-за чего все-таки криво стартует postgre?

Непрочитанное сообщение **zingel** » 2008-08-20 14:20:24

f0s писал(а):эм.. ты сейчас с кем разговаривал?
у меня 6.2 версия..

а поповоду сабжа, из-за чего все-таки криво стартует postgre?

it's possible that it is less than your kernel's SHMMIN

Непрочитанное сообщение **zingel** » 2008-08-20 14:23:13

патчить и пересобирать

f0s · Непрочитанное сообщение **f0s** » 2008-08-20 14:36:17

патчить ядро? у меня 6.2... что именно мне следует сделать?

Непрочитанное сообщение **zingel** » 2008-08-20 15:09:23

как минимум это:

http://archives.postgresql.org/pgsql-ge ... g01166.php

f0s · Непрочитанное сообщение **f0s** » 2008-08-20 15:13:19

за ссылку спасибо.

как минимум две ссылки из этой счылки не работают.. и овпрос там о 7-ой ветке постгре.. неужели в 8-ой ветке до сих пор не поправили это и надо применять патч??

Непрочитанное сообщение **zingel** » 2008-08-20 15:51:50

до 8.3 эти проблемы были.....в 8.3 я пока я не замечал

aleksey.kravchenko

Прежде чем разбираться с shared_buffers, надо сначала подключиться к серверу...

[f0s@fileserver] /usr/local/pgsql/data/> psql -h localhost postgres postgres
Password for user postgres:
psql: FATAL: password authentication failed for user "postgres"

1. В pg_hba.conf оставь одну строку:

Код: Выделить всё

host    all         all         127.0.0.1/32          trust

2. Перезапусти postgresql
3. Подключись к серверу:

Код: Выделить всё

# psql -h localhost postgres postgres

4. Смени пароль пользователя postgres:

Код: Выделить всё

postgres=# ALTER USER postgres PASSWORD 'secret';

5. В pg_hba.conf замени строку

Код: Выделить всё

host    all         all         127.0.0.1/32          trust

на

Код: Выделить всё

host    all             all     0.0.0.0/0               md5

6. Перезагрузи postgresql

P.S. Ты постгрес уже пропатчил одинэсовскими патчами?

aleksey.kravchenko

Дальше... Не спеши патчить... Попробуй сделать так:
1. Проверь текущие значения shmall, shmmax и semmap:

Код: Выделить всё

# sysctl -a | grep kern.ipc.shmall
# sysctl -a | grep kern.ipc.shmmax
# sysctl -a | grep kern.ipc.semmap

2. Добавь в /etc/sysctl.conf:

Код: Выделить всё

kern.ipc.shmall=32768
kern.ipc.shmmax=134217728
kern.ipc.semmap=256

3. Введи;

Код: Выделить всё

# sysctl -p

4. Измени в postgresql.conf значение shared_buffers, например:

Код: Выделить всё

shared_buffers = 240MB

5. Перезагрузи postgresql.

f0s · Непрочитанное сообщение **f0s** » 2008-08-21 9:41:00

постгре уже пропатченный от 1с.

пароль уже тоже сменил, подключаюсь к серверу нормально.
sysctl-и тоже уже давно по хелпу настроил:

Код: Выделить всё

[f0s@fileserver] /home/f0s/> sysctl -a | grep kern.ipc.shmall
kern.ipc.shmall: 32768
[f0s@fileserver] /home/f0s/> sysctl -a | grep kern.ipc.shmmax
kern.ipc.shmmax: 134217728
[f0s@fileserver] /home/f0s/> sysctl -a | grep kern.ipc.semmap
kern.ipc.semmap: 256

Код: Выделить всё

[f0s@fileserver] /home/f0s/> sysctl -p
sysctl: illegal option -- p
usage: sysctl [-bdehNnoqx] name[=value] ...
       sysctl [-bdehNnoqx] -a

добавил в /boot/loader.conf (правда после этого еще не перегружался):

Код: Выделить всё

set kern.ipc.semmni=256
set kern.ipc.semmns=512
set kern.ipc.semmnu=256

когда шаред_буфферс ставлю 248мб, появляется это:

Код: Выделить всё

Aug 21 10:35:29 fileserver postgres[35364]: [1-1] FATAL:  could not create shared memory segment: Invalid argument
Aug 21 10:35:29 fileserver postgres[35364]: [1-2] ПОДРОБНОСТИ:  Failed system call was shmget(key=5432001, size=272605184, 03600).
Aug 21 10:35:29 fileserver postgres[35364]: [1-3] ПОДСКАЗКА:  This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX
Aug 21 10:35:29 fileserver postgres[35364]: [1-4]  parameter.  You can either reduce the request size or reconfigure the kernel with larger SHMMAX.  To reduce the request size
Aug 21 10:35:29 fileserver postgres[35364]: [1-5]  (currently 272605184 bytes), reduce PostgreSQL's shared_buffers parameter (currently 31744) and/or its max_connections
Aug 21 10:35:29 fileserver postgres[35364]: [1-6]  parameter (currently 40).
Aug 21 10:35:29 fileserver postgres[35364]: [1-7]       If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising
Aug 21 10:35:29 fileserver postgres[35364]: [1-8]  the request size or reconfiguring SHMMIN is called for.
Aug 21 10:35:29 fileserver postgres[35364]: [1-9]       The PostgreSQL documentation contains more information about shared memory configuration.

если поставить: 128Мб, то:

Код: Выделить всё

Aug 21 10:37:15 fileserver postgres[35415]: [1-1] FATAL:  could not create shared memory segment: Invalid argument
Aug 21 10:37:15 fileserver postgres[35415]: [1-2] ПОДРОБНОСТИ:  Failed system call was shmget(key=5432001, size=144195584, 03600).
Aug 21 10:37:15 fileserver postgres[35415]: [1-3] ПОДСКАЗКА:  This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX
Aug 21 10:37:15 fileserver postgres[35415]: [1-4]  parameter.  You can either reduce the request size or reconfigure the kernel with larger SHMMAX.  To reduce the request size
Aug 21 10:37:15 fileserver postgres[35415]: [1-5]  (currently 144195584 bytes), reduce PostgreSQL's shared_buffers parameter (currently 16384) and/or its max_connections
Aug 21 10:37:15 fileserver postgres[35415]: [1-6]  parameter (currently 40).
Aug 21 10:37:15 fileserver postgres[35415]: [1-7]       If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising
Aug 21 10:37:15 fileserver postgres[35415]: [1-8]  the request size or reconfiguring SHMMIN is called for.
Aug 21 10:37:15 fileserver postgres[35415]: [1-9]       The PostgreSQL documentation contains more information about shared memory configuration.

если поставить 96Мб, то становится ок, но в лог сыпется теперь:

Код: Выделить всё

Aug 21 10:38:10 fileserver postgres[35461]: [3-1] FATAL:  отсутствует запись в pg_hba.conf для хоста "[local]", пользователя "pgsql", базы "postgres", SSL выкл.
Aug 21 10:38:11 fileserver postgres[35462]: [3-1] FATAL:  отсутствует запись в pg_hba.conf для хоста "[local]", пользователя "pgsql", базы "postgres", SSL выкл.
Aug 21 10:38:12 fileserver postgres[35463]: [3-1] FATAL:  отсутствует запись в pg_hba.conf для хоста "[local]", пользователя "pgsql", базы "postgres", SSL выкл.
Aug 21 10:38:13 fileserver postgres[35464]: [3-1] FATAL:  отсутствует запись в pg_hba.conf для хоста "[local]", пользователя "pgsql", базы "postgres", SSL выкл.

при это при запуске пишется:

Код: Выделить всё

[f0s@fileserver] /usr/local/pgsql/> /usr/local/etc/rc.d/postgresql start
could not start server

однако сам сервер работает, просто логи фигачится что "отсутсвует запись в pg_gba.conf...." (см. выше)
а так сервер работает.. к нему можно подключится...

Код: Выделить всё

[f0s@fileserver] /usr/local/pgsql/> ps -axj | grep pos
pgsql     35456     1 35456 35456    0 Ss    ??    0:00,09 /usr/local/bin/postgres -D /usr/local/pgsql/data
pgsql     35458 35456 35458 35458    0 Ss    ??    0:00,01 postgres: writer process    (postgres)
pgsql     35459 35456 35459 35459    0 Ss    ??    0:00,00 postgres: stats collector process    (postgres)
root      35532 34905 35531 34901    2 L+    p0    0:00,00 grep pos
[f0s@fileserver] /usr/local/pgsql/> psql -h localhost postgres pgsql
Password for user pgsql:
Welcome to psql 8.2.4 (server 8.2.9), the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# \q
[f0s@fileserver] /usr/local/pgsql/>

Непрочитанное сообщение **zingel** » 2008-08-21 9:43:09

прочитай мои посты

f0s · Непрочитанное сообщение **f0s** » 2008-08-21 10:19:28

zingel писал(а):прочитай мои посты

перешли плиз на мыло f0s@rambler.ru патч, или сделай выложи ввиде файла.. а то код сильно покорежился.

Непрочитанное сообщение **zingel** » 2008-08-21 11:31:38

уже

f0s · Непрочитанное сообщение **f0s** » 2008-08-21 12:12:12

убрал ключил "-w" в скрипте запуска- все теперь нормально стартует без ошибок, ни единого разрыва.

теперь осталась проблема следующего. Создаю в 1с Предприятие8.1 новую базу данных.

присваиваю ей имя test1c, выбираю "создать, в случае отсутсвия". 1с выдает сообщение:

Код: Выделить всё

Ошибка создания информационной базы:
ошибка информационной базы
ошибка при выполнении операции с информационной базой
ошибка СУБД:
ERROR: invalid value for parameter "l_messages": "en_US"

при это в логе постгре появляется:

Код: Выделить всё

Aug 21 12:26:29 fileserver postgres[49059]: [3-1] ERROR:  invalid value for parameter "lc_messages": "en_US"
Aug 21 12:26:29 fileserver postgres[49059]: [3-2] STATEMENT:  SET lc_messages to 'en_US';
Aug 21 12:26:29 fileserver postgres[49059]: [4-1] WARNING:  there is no transaction in progress

в конфиге постгре написано:

Код: Выделить всё

cat /var/db/postgresql/postgresql.conf | grep lc_mess
lc_messages = 'C'

при этом в /etc/rc.conf:

Код: Выделить всё

postgresql_enable="YES"
postgresql_class="pgsql"

в /etc/login.conf

Код: Выделить всё

    pgsql:\
            :lang=ru_RU.utf-8:\
            :setenv=LC_COLLATE=C:\
            :tc=default:

если поменять в конфиге postgresql.conf на следующие параметры:

Код: Выделить всё

lc_messages = 'ru_RU.UTF-8'
lc_monetary = 'ru_RU.UTF-8'
lc_numeric = 'ru_RU.UTF-8'
lc_time = 'ru_RU.UTF-8'

то в 1с та же ошибка, а в логах опять тоже самое:

Код: Выделить всё

Aug 21 12:38:00 fileserver postgres[49186]: [3-1] ERROR: п?п?п?п?яM-^@п?п?п? п?п?п?яM-^Gп?п?п?п? п?п?яM-^O п©п?яM-^@п?п?п?яM-^BяM-^@п? "lc_messages": "en_US"
Aug 21 12:38:00 fileserver postgres[49186]: [3-2] пM-^ZпM-^^пM-^\пM-^PпM-^]пM-^TпM-^P:  SET lc_messages to 'en_US';
Aug 21 12:38:00 fileserver postgres[49186]: [4-1] WARNING:  п?п?яM-^B яM-^BяM-^@п?п?п?п?п?яM-^Fп?п? п? п©яM-^@п?яM-^Fп?яM-^AяM-^Aп? п?яM-^Kп©п?п?п?п?п?п?яM-^O

если на

Код: Выделить всё

lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'

то в 1с та же ошибка, а в логах опять тоже самое:

Код: Выделить всё

Aug 21 12:40:10 fileserver postgres[49216]: [3-1] ERROR:  invalid value for parameter "lc_messages": "en_US"
Aug 21 12:40:10 fileserver postgres[49216]: [3-2] STATEMENT:  SET lc_messages to 'en_US';
Aug 21 12:40:10 fileserver postgres[49216]: [4-1] WARNING:  there is no transaction in progress

aleksey.kravchenko

f0s писал(а): в /etc/login.conf
Код: Выделить всё
    pgsql:\
            :lang=ru_RU.utf-8:\
            :setenv=LC_COLLATE=C:\
            :tc=default:

pgsql системный пользователь или только в постгресе?

какая локаль? С какой локалью инициализировал бд? Какая версия постгрес?

f0s · Непрочитанное сообщение **f0s** » 2008-08-22 9:44:49

pgsql системный. локаль поставил ему en_US.UTF-8, в postgresql.conf тоже такую же поставил вручную. версия постгре 8.2.9
есть сделал симлин в /usr/share/locale для en_US en_US.UTF-8

Код: Выделить всё

[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

и, о чудо! заработало.. но стало ругаться на другую ошибку:

в 1с пишет что-то про mchar, а влогах:

Код: Выделить всё

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;

продолжение следует.. лог просто большой

f0s · Непрочитанное сообщение **f0s** » 2008-08-22 9:50:02

Код: Выделить всё

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]

f0s · Непрочитанное сообщение **f0s** » 2008-08-22 9:55:23

Код: Выделить всё

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

f0s · Непрочитанное сообщение **f0s** » 2008-08-22 10:06:53

по поводу этой ошибки прочитал:

Код: Выделить всё

Ошибка "ERROR could not access file "$LIBDIR/MCHAR": No such file or directory." и аналогичные, вызваны тем, что библиотеки для работы с этими типами находятся в 'contrib-ах' постгреса. В поставке или при сборке из srpm-cа собираются в отдельный rpm(например, postgresql-contrib-8.2.4-1.1C.x86_64.rpm), который обязательно установить. Кто собирает из сырцов - сам догадается, что делать 8).
Таким образом, должны быть установлены -

# rpm -qa | grep -i postgres
postgresql-server-8.2.4-1.1C
postgresql-8.2.4-1.1C
postgresql-contrib-8.2.4-1.1C
postgresql-libs-8.2.4-1.1C

где бы взять эти contrib, libs для freebsd?
нашел вот что:

Код: Выделить всё

[f0s@fileserver] /usr/ports/> make search name=contrib | grep postgre
Port:   postgresql-contrib-8.2.9_1
Path:   /usr/ports/databases/postgresql-contrib
B-deps: bison-2.3_4,1 gettext-0.17_1 gmake-3.81_3 libiconv-1.11_1 m4-1.4.11,1 postgresql-client-8.2.9
R-deps: gettext-0.17_1 libiconv-1.11_1 postgresql-client-8.2.9
WWW:    http://www.postgresql.org/

сейчас пробую установить...

aleksey.kravchenko

и, о чудо! заработало..

Это, конечно, молодца!

где бы взять эти contrib, libs для freebsd?
нашел вот что:

Код: Выделить всё
[f0s@fileserver] /usr/ports/> make search name=contrib | grep postgre
Port: postgresql-contrib-8.2.9_1
Path: /usr/ports/databases/postgresql-contrib
B-deps: bison-2.3_4,1 gettext-0.17_1 gmake-3.81_3 libiconv-1.11_1 m4-1.4.11,1 postgresql-client-8.2.9
R-deps: gettext-0.17_1 libiconv-1.11_1 postgresql-client-8.2.9
WWW: http://www.postgresql.org/

Не...ты же патчил 1с патчами? Значит лезем в

Код: Выделить всё

# cd /usr/ports/databases/postgresql82-server/work/postgresql-8.2.9/contrib

и делаем

Код: Выделить всё

# gmake install

Потом проверь в каталоге установки библиотек постгреса файлик mchar.so.
Должно помочь...

P.S. Для установки contrib понадобится icu (devel/icu). Может еще что-то..

aleksey.kravchenko

Как там у тебя? получилось?

f0s · Непрочитанное сообщение **f0s** » 2008-08-25 10:18:25

пробую:

Код: Выделить всё

[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.9/contrib/> gmake install
Makefile:5: ../src/Makefile.global: No such file or directory
gmake: *** Нет правила для сборки цели `../src/Makefile.global'.  Останов.

переименовал Makefile.global.in в Makefile.global:

Код: Выделить всё

[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.9/contrib/> gmake install
../src/Makefile.global:318: ../src/Makefile.port: No such file or directory
gmake: *** Нет правила для сборки цели `../src/Makefile.port'.  Останов.

forum.lissyara.su

не запускается постгре

не запускается постгре

Услуги хостинговой компании Host-Food.ru

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре

Re: не запускается постгре