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
*** 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 ||
---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate