Discussion:
co existance of tsearch V1 and V2 in same database.
(too old to reply)
Rajesh Kumar Mallah
2004-02-10 16:37:15 UTC
Permalink
Greetings,

Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?


regds
mallah.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Oleg Bartunov
2004-02-10 19:58:45 UTC
Permalink
Post by Rajesh Kumar Mallah
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
quite peacefully, no problem
Post by Rajesh Kumar Mallah
regds
mallah.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ***@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Rajesh Kumar Mallah
2004-02-10 20:29:06 UTC
Permalink
Post by Oleg Bartunov
Post by Rajesh Kumar Mallah
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
quite peacefully, no problem
Thank You,
thats a releif to know.

regds
mallah.
Post by Oleg Bartunov
Post by Rajesh Kumar Mallah
regds
mallah.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org
Oleg Bartunov
2004-02-13 14:28:38 UTC
Permalink
Post by Oleg Bartunov
Post by Rajesh Kumar Mallah
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
quite peacefully, no problem
Following error is got if installation of tsearch2 is attempted
in a database containing tsearch1
can u pls suggest?
psql tsearch < tsearch2.sql
SET
BEGIN
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_dict_pkey" for table "pg_ts_dict"
CREATE TABLE
ERROR: function "lexize" already exists with same argument types
ERROR: current transaction is aborted, commands ignored until end of
transaction block
I don't believe :) There were no lexize function in tsearch1.
Please try on fresh database.
Post by Oleg Bartunov
Post by Rajesh Kumar Mallah
regds
mallah.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ***@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
Rajesh Kumar Mallah
2004-02-13 20:03:32 UTC
Permalink
Post by Oleg Bartunov
Post by Oleg Bartunov
Post by Rajesh Kumar Mallah
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
quite peacefully, no problem
Following error is got if installation of tsearch2 is attempted
in a database containing tsearch1
can u pls suggest?
psql tsearch < tsearch2.sql
SET
BEGIN
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_dict_pkey" for table "pg_ts_dict"
CREATE TABLE
ERROR: function "lexize" already exists with same argument types
ERROR: current transaction is aborted, commands ignored until end of
transaction block
I don't believe :) There were no lexize function in tsearch1.
Please try on fresh database.
Apologies, it did work.

regds
mallah.
Post by Oleg Bartunov
Post by Oleg Bartunov
Post by Rajesh Kumar Mallah
regds
mallah.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)
Loading...