From: manchicken <manchicken@notsosoft.net>
To: pgsql-sql@postgresql.org
Subject: Re: tsearch2() trigger and domain types...
Date: Tue, 19 Jun 2007 12:43:24 -0500
Message-ID: <200706191243.25057.manchicken@notsosoft.net> (raw)
In-Reply-To: <27097.1182262103@sss.pgh.pa.us>
References: <200706181610.00270.manchicken@notsosoft.net>
<200706190855.47398.manchicken@notsosoft.net>
<27097.1182262103@sss.pgh.pa.us>
On Tuesday 19 June 2007 09:08:23 Tom Lane wrote:
> oidtype = getBaseType(oidtype);
I patched this in a FreeBSD 6.2 port. Attached is the patch. Thanks a lot
for the help on this. It works like a charm.
--
~ manchicken <><
(A)bort, (R)etry, (I)nfluence with large hammer.
09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.htmlAttachments:tsearch2_domains_fix.patch (text/x-diff, 407B) download
*** tsvector.c Tue Jun 19 12:39:06 2007
--- tsvector.c.patched Tue Jun 19 12:38:37 2007
*************** tsearch2(PG_FUNCTION_ARGS)
*** 890,895 ****
--- 890,896 ----
continue;
}
oidtype = SPI_gettypeid(rel->rd_att, numattr);
+ oidtype = getBaseType(oidtype);
/* We assume char() and varchar() are binary-equivalent to text */
if (!(oidtype == TEXTOID ||
oidtype == VARCHAROID ||
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: manchicken@notsosoft.net
Subject: Re: tsearch2() trigger and domain types...
In-Reply-To: <200706191243.25057.manchicken@notsosoft.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox