Skip site navigation (1) Skip section navigation (2)

Re: sleep function

From: Sanjay Singh <sanjjay(at)igcar(dot)ernet(dot)in>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: John DeSoi <jd(at)icx(dot)net>, PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: sleep function
Date: 2004-09-15 09:22:25
Message-ID: 414809D1.2040509@igcar.ernet.in (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)icx(dot)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(at)igcar(dot)ernet(dot)in            |
|         sanjjay_in(at)yahoo(dot)com              |
*********************************************


In response to

pgsql-sql by date

Next:From: StefDate: 2004-09-15 12:24:45
Subject: Preserving column order when recreating table.
Previous:From: IainDate: 2004-09-15 03:03:30
Subject: implementing an out-of-transaction trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group