Re: [SQL] sleep function

2004-09-15 Thread Sanjay Singh
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 wro

Re: [SQL] sleep function

2004-08-23 Thread John DeSoi
Hi Greg, On Aug 22, 2004, at 11:52 PM, Greg Stark wrote: test=# create or replace function sleep(integer) returns integer as 'return sleep(shift)' language plperlu; CREATE FUNCTION The original request was for something in built-in to PostgreSQL. I have not used plperl (or any of the other pl la

Re: [SQL] sleep function

2004-08-22 Thread Greg Stark
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

Re: [SQL] sleep function

2004-08-11 Thread John DeSoi
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. Best, John DeSoi, P

Re: [SQL] sleep function

2004-08-10 Thread Bruce Momjian
John DeSoi wrote: > Is there a sleep function of some kind? I wanted to simulate a query > taking a long time to execute for testing purposes. 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. -- Bruce Momjian