Hi All, I am getting this message while I am trying to implement tsearch.
java.sql.SQLException: ERROR: could not find tsearch config by locale
what could be the problem Please help bye Sanjay
Greg Stark wrote:
John DeSoi <[EMAIL PROTECTED]> writes:
On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote:
I can't think of one, no. I think you will have to use one of the server-side languages and call a sleep in there.
This is no good in the real world since it pounds the CPU, but it worked well enough for my testing purposes.
You went the long way around. I think what he meant was something as simple as:
bash-2.05b$ /usr/lib/postgresql/bin/createlang -U postgres plperlu test
bash-2.05b$ psql -d test -U postgres Welcome to psql 7.4.2, 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
test=# create or replace function sleep(integer) returns integer as 'return sleep(shift)' language plperlu; CREATE FUNCTION
test=# \timing Timing is on.
test=# select sleep(10) ;
sleep -------
10
(1 row)
Time: 10002.493 ms
-- Sanjay Singh
********************************************* | Scientific Officer / D, | | Library & Information Services, | | Indira Gandhi Centre for Atomic Research, | | Kalpakkam - 603102, Tamil Nadu (India) | | Phone : 0091 4114 280096(O) | | 0091 9894258801(R) | | Email : [EMAIL PROTECTED] | | [EMAIL PROTECTED] | *********************************************
---------------------------(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
