Re: [BUGS] tsvector_update_trigger() fails in 9.6 on character(2) column - Mailing list pgsql-bugs

From Matt Magoffin
Subject Re: [BUGS] tsvector_update_trigger() fails in 9.6 on character(2) column
Date
Msg-id 2C65FF85-4F9C-4432-89F8-1D1609C422C7@msqr.us
Whole thread Raw
In response to Re: [BUGS] tsvector_update_trigger() fails in 9.6 on character(2) column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
> On 9/03/2017, at 4:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Not entirely sure that it's worth the trouble, as this seems like a rather
> strange use-case to me.

Thanks for the info, Tom. I can speak to the use-case in my situation, where the char(2) column is but one of many
columnsadded to a tsvector column via tsvector_update_trigger(), so that general user-entered search queries can
execute(quickly) against the tsvector column alone. 

Kind regards,
Matt

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] tsvector_update_trigger() fails in 9.6 on character(2) column
Next
From: Stepan Yankevych
Date:
Subject: Re: [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker