[ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Rajesh Kumar Mallah
Hi , We recently upgraded from PostgreSQL 8.1.5 to PostgreSQL 8.2.0. looks like rank_cd function is giving problem . tradein_clients=> CREATE TABLE test (name text , name_vec tsvector); CREATE TABLE tradein_clients=> INSERT INTO test (name ,name_vec) values ('hello world' , to_tsvector('hello wo

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
You need to read documentation ! rank_cd accepts the same args as rank() function. Oleg On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: Hi , We recently upgraded from PostgreSQL 8.1.5 to PostgreSQL 8.2.0. looks like rank_cd function is giving problem . tradein_clients=> CREATE TABLE test (name

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Rajesh Kumar Mallah
On 12/8/06, Oleg Bartunov wrote: You need to read documentation ! rank_cd accepts the same args as rank() function. Dear Oleg, Could you please elaborate a bit more if time permits. our application is old and it was working fine in 8.1.5. do i need to change the sql to use a different functio

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: On 12/8/06, Oleg Bartunov wrote: You need to read documentation ! rank_cd accepts the same args as rank() function. Dear Oleg, Could you please elaborate a bit more if time permits. our application is old and it was working fine in 8.1.5. do i

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Rajesh Kumar Mallah
On 12/8/06, Oleg Bartunov wrote: On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > On 12/8/06, Oleg Bartunov wrote: >> You need to read documentation ! rank_cd accepts the same args as rank() >> function. > > Dear Oleg, > > Could you please elaborate a bit more if time permits. > our applicatio

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: Dear Oleg, In local development server. the old functions still exists in postgresql catalogs. But probably they are missing in the newer version of tsearch2.so that came with 8.2.0 . And hence postgres is crashing. I feel this should have been

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Tom Lane
Oleg Bartunov writes: > You need to read documentation ! rank_cd accepts the same args as rank() > function. Nonetheless, dumping core on bad input is not acceptable behavior ... regards, tom lane ---(end of broadcast)--- T

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Rajesh Kumar Mallah
On 12/8/06, Oleg Bartunov wrote: On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > Dear >Oleg, > In local development server. the old functions still exists in > postgresql catalogs. But probably they are missing in the > newer version of tsearch2.so that came with 8.2.0 . And hence > postg

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
On Fri, 8 Dec 2006, Tom Lane wrote: Oleg Bartunov writes: You need to read documentation ! rank_cd accepts the same args as rank() function. Nonetheless, dumping core on bad input is not acceptable behavior ... we already resolved the situation. This is mostly problem of missing release n

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Rajesh Kumar Mallah
On 12/8/06, Oleg Bartunov wrote: On Fri, 8 Dec 2006, Tom Lane wrote: > Oleg Bartunov writes: >> You need to read documentation ! rank_cd accepts the same args as rank() >> function. > > Nonetheless, dumping core on bad input is not acceptable behavior ... we already resolved the situation. Th

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: On 12/8/06, Oleg Bartunov wrote: On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > Dear >Oleg, > In local development server. the old functions still exists in > postgresql catalogs. But probably they are missing in the > newer version of tse

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > On Fri, 2006-12-08 at 10:47 -0500, Tom Lane wrote: >> Nonetheless, dumping core on bad input is not acceptable behavior ... > Is it time to require test cases for contrib modules? tsearch2 *has* a regression test. ATM it sounds like the problem is

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Joshua D. Drake
On Fri, 2006-12-08 at 11:12 -0500, Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > On Fri, 2006-12-08 at 10:47 -0500, Tom Lane wrote: > >> Nonetheless, dumping core on bad input is not acceptable behavior ... > > > Is it time to require test cases for contrib modules? > > tsea

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Rajesh Kumar Mallah
On 12/8/06, Oleg Bartunov wrote: On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > On 12/8/06, Oleg Bartunov wrote: >> On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: >> >> > Dear >> >Oleg, >> > In local development server. the old functions still exists in >> > postgresql catalogs. But prob

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres [Update]

2006-12-08 Thread Rajesh Kumar Mallah
Dear Oleg, In local development server. the old functions still exists in postgresql catalogs. But probably they are missing in the newer version of tsearch2.so that came with 8.2.0 . And hence postgres is crashing. I feel this should have been informed in the release notes. tradein_clients=