[GENERAL] seg fault with tsearch2

2005-04-07 Thread Joel Leyh
I have Pg installed on i386 NetBSD from the NetBSD package manager. I then installed tsearch2 and used its default installation. I then also got the source and built from it, with debugging enabled. Again I installed tsearch2 but my results were the same. Created a new database, added a table with

Re: [GENERAL] seg fault with tsearch2

2005-04-07 Thread Joel Leyh
Ah ok. I must have copied it incorectly. I am using 8.0.1 from the latest binary build from NetBSD. The source I used was postgresql-8.0.1.tar.bz2 stable release. I will try the CVS release to see if it's fixed. --Joel On Apr 7, 2005 12:26 PM, Tom Lane <[EMAIL PROTECTED]> wrote:

Re: [GENERAL] seg fault with tsearch2

2005-04-09 Thread Joel Leyh
t; So, the only conclusion I can reach is this problem is some OS dependant bug, which apparently has been fixed in 8.0.2beta. --Joel On Apr 7, 2005 9:04 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Joel Leyh <[EMAIL PROTECTED]> writes: > > Same problem, same function causing t

[GENERAL] tsearch2 trigger

2005-04-21 Thread Joel Leyh
I am writing a tsearch2 trigger function in plperl. I would like to run a query similar to this: setweight(to_tsvector(col1),'b') || setweight(to_tsvector(col2),'a') and insert the result into the tsvector column. I know I can call spi_exec_query('select ...') and insert the result, but is this t