pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedset_curcfg('default') + tsearch1 call = postmaster crash
4+ messages / 2 participants
[nested] [flat]
* set_curcfg('default') + tsearch1 call = postmaster crash
@ 2004-04-21 17:16 Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Kumar Mallah @ 2004-04-21 17:16 UTC (permalink / raw)
To: pgsql-admin
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.
!>
!>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: set_curcfg('default') + tsearch1 call = postmaster crash
@ 2004-04-22 03:44 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2004-04-22 03:44 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-admin
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> 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.
> Any solution ?
Possibly you should be running something newer than 7.4RC2.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: set_curcfg('default') + tsearch1 call = postmaster crash
@ 2004-04-22 04:10 Rajesh Kumar Mallah <mallah@trade-india.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Kumar Mallah @ 2004-04-22 04:10 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom Lane wrote:
>Rajesh Kumar Mallah <mallah@trade-india.com> writes:
>
>
>>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.
>
>
>
>>Any solution ?
>>
>>
>
>Possibly you should be running something newer than 7.4RC2.
>
>
OT: can i do it without dump --> initdb --> reload?
> regards, tom lane
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: set_curcfg('default') + tsearch1 call = postmaster crash
@ 2004-04-22 04:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-04-22 04:25 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-admin
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
>> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-04-22 04:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-21 17:16 set_curcfg('default') + tsearch1 call = postmaster crash Rajesh Kumar Mallah <mallah@trade-india.com>
2004-04-22 03:44 ` Re: set_curcfg('default') + tsearch1 call = postmaster crash Tom Lane <tgl@sss.pgh.pa.us>
2004-04-22 04:10 ` Re: set_curcfg('default') + tsearch1 call = postmaster crash Rajesh Kumar Mallah <mallah@trade-india.com>
2004-04-22 04:25 ` Re: set_curcfg('default') + tsearch1 call = postmaster crash Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox