From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | akopciuch(at)bddf(dot)ca, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: tsvector/tsearch equality and/or portability issue |
Date: | 2006-08-24 18:27:05 |
Message-ID: | 44EDEF79.8050001@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> "Andrew J. Kopciuch" <akopciuch(at)bddf(dot)ca> writes:
>> On Thursday 24 August 2006 10:34, Stefan Kaltenbrunner wrote:
>>> devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector;
>>> ?column?
>>> ----------
>>> f
>>> (1 row)
>
>> This could be an endianess issue?
>
> Apparently not, it works for me on HPPA (big endian) and on Darwin/PPC
> (ditto). I'm testing CVS HEAD though, not 8.1 branch.
>
> However ... I also see that tsearch2's regression test is dumping
> core on my OS X machine. I haven't cvs update'd for awhile on this
> machine though --- will bring it to HEAD and report back.
>
> Can some other people try this? We need to get a handle on which
> machines show the problem.
I am trying on current copy of HEAD.. however:
jd(at)scratch:~/pgsqldev$ bin/psql -U postgres postgres <
share/contrib/tsearch2.sql
SET
BEGIN
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_dict_pkey" for table "pg_ts_dict"
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
INSERT 57434167 1
CREATE FUNCTION
CREATE FUNCTION
INSERT 57434170 1
ERROR: could not find function "snb_ru_init_koi8" in file
"/usr/local/pgsql/lib/tsearch2.so"
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
I will try on 8.1 in a moment.
Joshua D. Drake
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-08-24 18:28:29 | Re: tsvector/tsearch equality and/or portability issue |
Previous Message | Teodor Sigaev | 2006-08-24 18:20:55 | Re: tsvector/tsearch equality and/or portability issue |