From: "Michael D. Stemle, Jr." <manchicken@notsosoft.net>
To: pgsql-sql@postgresql.org
Subject: tsearch2() trigger and domain types...
Date: Mon, 18 Jun 2007 16:09:59 -0500
User-Agent: KMail/1.9.7
MIME-Version: 1.0
Content-Type: Multipart/Mixed;
  boundary="Boundary-00=_oSvdG2qUwr3+BSB"
Message-Id: <200706181610.00270.manchicken@notsosoft.net>

--Boundary-00=_oSvdG2qUwr3+BSB
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Okay, so I have an interesting problem that I'm having a hard time figuring 
out.

For standardization in my database I use a domain (login_t) for my login 
column in my profile table.  I'm trying to use the tsearch2() trigger to 
index several columns, including the login column, into a column 
called "search_index."

So I added the trigger as attached with the hope that it would do just that.

Well, here's what I get upon every update and insert to the profile table:
WARNING:  TSearch: 'login' is not of character type

I've tried casting and such, but nothing seems to work.  Anybody got any 
ideas?  Thanks in advance.

-- 
~ Michael D. Stemle, Jr. <><
(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=_oSvdG2qUwr3+BSB
Content-Type: text/plain; charset="us-ascii";
	name="tgr_profile_search_index-on-public_profile_DDL.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="tgr_profile_search_index-on-public_profile_DDL.sql"

CREATE TRIGGER "tgr_profile_search_index" AFTER INSERT OR UPDATE 
ON "public"."profile" FOR EACH ROW 
EXECUTE PROCEDURE "public"."tsearch2"(search_index, description, interests, login, hometown, email, url, im_names, name);

COMMENT ON TRIGGER "tgr_profile_search_index" ON "public"."profile"
IS 'This trigger will keep the search index up to date for the profile table.  This index is based on the description and the interests columns.';

--Boundary-00=_oSvdG2qUwr3+BSB--