Message-ID: <414809D1.2040509@igcar.ernet.in>
Date: Wed, 15 Sep 2004 14:52:25 +0530
From: Sanjay Singh <sanjjay@igcar.ernet.in>
Organization: Indira Gandhi Centre for Atomic Research
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030225
MIME-Version: 1.0
To: Greg Stark <gsstark@mit.edu>
Cc: John DeSoi <jd@icx.net>, PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: sleep function
References: <200408101457.i7AEvvc15187@candle.pha.pa.us><46D44C5D-EBCF-11D8-
	A1CD-000A95B03262@icx.net> <87hdqu5x5q.fsf@stark.xeocode.com>
In-Reply-To: <87hdqu5x5q.fsf@stark.xeocode.com>
Content-Type: text/plain;
	charset=us-ascii;
	format=flowed
Content-Transfer-Encoding: 7bit

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              |
*********************************************