Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 81AAC9FB531 for ; Tue, 19 Jun 2007 14:44:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 26856-04 for ; Tue, 19 Jun 2007 14:44:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from raptor.webhostserver.biz (raptor.webhostserver.biz [208.101.26.91]) by postgresql.org (Postfix) with ESMTP id 0BBD09FB41C for ; Tue, 19 Jun 2007 14:44:24 -0300 (ADT) Received: from 74-134-94-223.dhcp.insightbb.com ([74.134.94.223] helo=[192.168.2.104]) by raptor.webhostserver.biz with esmtp (Exim 4.66) (envelope-from ) id 1I0hkc-0000OS-Lu for pgsql-sql@postgresql.org; Tue, 19 Jun 2007 11:44:23 -0600 From: manchicken Organization: notsosoft.net To: pgsql-sql@postgresql.org Subject: Re: tsearch2() trigger and domain types... Date: Tue, 19 Jun 2007 12:43:24 -0500 User-Agent: KMail/1.9.7 References: <200706181610.00270.manchicken@notsosoft.net> <200706190855.47398.manchicken@notsosoft.net> <27097.1182262103@sss.pgh.pa.us> In-Reply-To: <27097.1182262103@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: Multipart/Mixed; boundary="Boundary-00=_9WBeGGHfG6hi/Zd" Message-Id: <200706191243.25057.manchicken@notsosoft.net> X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - raptor.webhostserver.biz X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - notsosoft.net X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/142 X-Sequence-Number: 28632 --Boundary-00=_9WBeGGHfG6hi/Zd Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.html --Boundary-00=_9WBeGGHfG6hi/Zd Content-Type: text/x-diff; charset="utf-8"; name="tsearch2_domains_fix.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="tsearch2_domains_fix.patch" *** 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 || --Boundary-00=_9WBeGGHfG6hi/Zd--