From: Sanjay Singh <sanjjay@igcar.ernet.in>
To: Greg Stark <gsstark@mit.edu>
Cc: John DeSoi <jd@icx.net>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: sleep function
Date: Wed, 15 Sep 2004 14:52:25 +0530
Message-ID: <414809D1.2040509@igcar.ernet.in> (raw)
In-Reply-To: <87hdqu5x5q.fsf@stark.xeocode.com>
References: <200408101457.i7AEvvc15187@candle.pha.pa.us>
<46D44C5D-EBCF-11D8- A1CD-000A95B03262@icx.net>
<87hdqu5x5q.fsf@stark.xeocode.com>
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 |
*********************************************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sanjjay@igcar.ernet.in, gsstark@mit.edu, jd@icx.net
Subject: Re: sleep function
In-Reply-To: <414809D1.2040509@igcar.ernet.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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