From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael D. Stemle, Jr. <manchicken@notsosoft.net>
Cc: pgsql-sql@postgresql.org, Oleg Bartunov <oleg@sai.msu.su>
Cc: Teodor Sigaev <teodor@sigaev.ru>
Subject: Re: tsearch2() trigger and domain types...
Date: Mon, 18 Jun 2007 18:59:50 -0400
Message-ID: <10334.1182207590@sss.pgh.pa.us> (raw)
In-Reply-To: <200706181610.00270.manchicken@notsosoft.net>
References: <200706181610.00270.manchicken@notsosoft.net>
"Michael D. Stemle, Jr." <manchicken@notsosoft.net> 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
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: tgl@sss.pgh.pa.us, manchicken@notsosoft.net, oleg@sai.msu.su, teodor@sigaev.ru
Subject: Re: tsearch2() trigger and domain types...
In-Reply-To: <10334.1182207590@sss.pgh.pa.us>
* 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