set_curcfg('default') + tsearch1 call = postmaster crash

[Rajesh Kumar Mallah]

Greetings,

in my database i have both tsearch1 and tsearch2 .
the following sequence of commands lead to this
repeatble problem .

Any solution ?

Regds
mallah.


Welcome to psql 7.4RC2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

tradein_clients=# SELECT version();
version
--------------------------------------------------------------
PostgreSQL 7.4RC2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

tradein_clients=#
tradein_clients=# SELECT public.set_curcfg('default');
set_curcfg
------------

(1 row)

tradein_clients=# SELECT 'herbal tea'::txtidx ## 'tea|herbal';
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
!>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Tom Lane]

Possibly you should be running something newer than 7.4RC2.

OT: can i do it without dump --> initdb --> reload?

I think so; check the rev history to see if any initdb-forcing changes
happened between RC2 and final. Or just see if an updated postmaster
will start ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Tom Lane]

Post by Rajesh Kumar Mallah
in my database i have both tsearch1 and tsearch2 .
the following sequence of commands lead to this
repeatble problem .

I get a "t" result in 7.4 tip.

Post by Rajesh Kumar Mallah
Any solution ?

Possibly you should be running something newer than 7.4RC2.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Rajesh Kumar Mallah]

Post by Tom Lane

Post by Rajesh Kumar Mallah
in my database i have both tsearch1 and tsearch2 .
the following sequence of commands lead to this
repeatble problem .

I get a "t" result in 7.4 tip.

Post by Rajesh Kumar Mallah
Any solution ?

Possibly you should be running something newer than 7.4RC2.

OT: can i do it without dump --> initdb --> reload?

Post by Tom Lane
regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match