Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 26FFF9FB7E6 for ; Mon, 18 Jun 2007 19:59:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 76320-10 for ; Mon, 18 Jun 2007 19:59:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 623E69FA589 for ; Mon, 18 Jun 2007 19:59:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l5IMxohY010335; Mon, 18 Jun 2007 18:59:50 -0400 (EDT) To: "Michael D. Stemle, Jr." cc: pgsql-sql@postgresql.org, Oleg Bartunov , Teodor Sigaev Subject: Re: tsearch2() trigger and domain types... In-reply-to: <200706181610.00270.manchicken@notsosoft.net> References: <200706181610.00270.manchicken@notsosoft.net> Comments: In-reply-to "Michael D. Stemle, Jr." message dated "Mon, 18 Jun 2007 16:09:59 -0500" Date: Mon, 18 Jun 2007 18:59:50 -0400 Message-ID: <10334.1182207590@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/136 X-Sequence-Number: 28626 "Michael D. Stemle, Jr." writes: > For standardization in my database I use a domain (login_t) for my login > column in my profile table. > Well, here's what I get upon every update and insert to the profile table: > WARNING: TSearch: 'login' is not of character type The tsearch trigger seems to insist that the column be text, varchar(n), or char(n) ... no domains need apply :-( I'm not real sure why it doesn't just invoke the column's output function and be datatype-agnostic. Or at least do that when the shortcut "I know what text looks like" path isn't applicable. regards, tom lane