Good [morning|day|evening|night],
A new message has been posted to DataparkSearch Engine forum at
http://www.dataparksearch.org/
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Name: vk
Subject: Re: ���������� ������������, ������������ indexer
�������. � ������ ���, �������� ��� ����� ������� DPS 4.28, ������ ���
����������
vk>/usr/local/sbin/indexer -Ecreate
����� ����� ����������� �� �������:
SQL>SQL>'CREATE UNIQUE INDEX "url_url" ON "url" ( "url" )'
SQL>'CREATE UNIQUE INDEX "url_urlike" ON "url" ( "url" text_pattern_ops )'
{sqldbms.c:2911} Query: CREATE UNIQUE INDEX "url_urlike" ON "url" ( "url"
text_pattern_ops )
SQL-server message: ERROR: DefineIndex: operator class
"text_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "text_pattern_ops" not supported by access
method "btree"
. . . .
SQL>'CREATE INDEX uinfo_snamelike ON urlinfo (sname text_pattern_ops)'
{sqldbms.c:2911} Query: CREATE INDEX uinfo_snamelike ON urlinfo (sname
text_pattern_ops)
SQL-server message: ERROR: DefineIndex: operator class
"text_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "text_pattern_ops" not supported by access
method "btree"
SQL>'CREATE INDEX uinfo_svallike ON urlinfo (sval text_pattern_ops)'
{sqldbms.c:2911} Query: CREATE INDEX uinfo_svallike ON urlinfo (sval
text_pattern_ops)
SQL-server message: ERROR: DefineIndex: operator class
"text_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "text_pattern_ops" not supported by access
method "btree"
. . . .
SQL>'CREATE INDEX "dict_wordlike" ON "dict" ( "word" text_pattern_ops )'
{sqldbms.c:2911} Query: CREATE INDEX "dict_wordlike" ON "dict" ( "word"
text_pattern_ops )
SQL-server message: ERROR: DefineIndex: operator class
"text_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "text_pattern_ops" not supported by access
method "btree"
. . . . .
SQL>'CREATE UNIQUE INDEX srv_urlike ON server (command, url text_pattern_ops)'
{sqldbms.c:2911} Query: CREATE UNIQUE INDEX srv_urlike ON server (command, url
text_pattern_ops)
SQL-server message: ERROR: DefineIndex: operator class
"text_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "text_pattern_ops" not supported by access
method "btree"
SQL>'CREATE INDEX srv_tag ON server (tag text_pattern_ops)'
{sqldbms.c:2911} Query: CREATE INDEX srv_tag ON server (tag text_pattern_ops)
SQL-server message: ERROR: DefineIndex: operator class
"text_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "text_pattern_ops" not supported by access
method "btree"
. . . .
SQL>'CREATE INDEX cat_pathlike ON categories (path varchar_pattern_ops)'
{sqldbms.c:2911} Query: CREATE INDEX cat_pathlike ON categories (path
varchar_pattern_ops)
SQL-server message: ERROR: DefineIndex: operator class
"varchar_pattern_ops" not supported by access method "btree"
ERROR: DefineIndex: operator class "varchar_pattern_ops" not supported by
access method "btree"
. . . . .
SQL>SQL>SQL>
97 queries sent, 90 succeeded, 7 failed
��� ��� ������ ���� ��������� � ���������� PosgreSQL ��� ����� ��� �������
������ ���� ��������� ����� �������� vk>/usr/local/sbin/indexer -Ecreate ?
� ����������� �� ����, � ���������, �� ���������...
�������.
� ���������,
VK
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Read the full topic here:
http://www.dataparksearch.org/cgi-bin/simpleforum.cgi?fid=04;topic_id=1105965199
