Re: sleep function

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 <jd@icx.net> 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 : sanjjay@igcar.ernet.in            |
|         sanjjay_in@yahoo.com              |
*********************************************