On Wed, Aug 24, 2005 at 12:49:57PM -0400, Bruce Momjian wrote:
>
> Added to TODO:
>
> o Add sleep() to PL/PgSQL
Just to PL/pgSQL? If we're going to add it (which doesn't seem to
be decided yet), why not as an ordinary function that could be
called from SQL as well?
--
Michael Fuhr
--
Michael Fuhr wrote:
> On Wed, Aug 24, 2005 at 12:49:57PM -0400, Bruce Momjian wrote:
> >
> > Added to TODO:
> >
> > o Add sleep() to PL/PgSQL
>
> Just to PL/pgSQL? If we're going to add it (which doesn't seem to
> be decided yet), why not as an ordinary function that could be
> called f
Added to TODO:
o Add sleep() to PL/PgSQL
---
Robert Treat wrote:
> On Monday 22 August 2005 11:53, Tom Lane wrote:
> > Robert Treat <[EMAIL PROTECTED]> writes:
> > >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrot
On Mon, Aug 22, 2005 at 11:53:22AM -0400, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote:
> >>> To others who've written their own sleep() function: what are you
> >>> using it for?
>
> > I know I've used one for a script that reind
On Monday 22 August 2005 11:53, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote:
> >>> To others who've written their own sleep() function: what are you
> >>> using it for?
> >
> > I know I've used one for a script that reindexes vari
Robert Treat <[EMAIL PROTECTED]> writes:
>> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote:
>>> To others who've written their own sleep() function: what are you
>>> using it for?
> I know I've used one for a script that reindexes various tables on an
> old 7.3 server. I put a sleep of 20 second
Greg Stark wrote:
"Dave Page" writes:
Sure it's trivial in various languages, even in trusted PL/Tcl:
CREATE FUNCTION sleep(integer) RETURNS void AS $$
after [expr $1 * 1000]
$$ LANGUAGE pltcl STRICT;
Do any of the trusted languages count branches and abort after some large
numbe
"Dave Page" writes:
> Sure it's trivial in various languages, even in trusted PL/Tcl:
>
> CREATE FUNCTION sleep(integer) RETURNS void AS $$
> after [expr $1 * 1000]
> $$ LANGUAGE pltcl STRICT;
Do any of the trusted languages count branches and abort after some large
number to prevent trusted c
On Mon, 2005-08-22 at 08:14, John DeSoi wrote:
>
> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote:
>
> > To others who've written their own sleep() function: what are you
> > using it for?
>
>
> I need it for API and user interface testing. I want to be sure
> things behave correctly when a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> In any case, I wonder how many people, not having a sleep() function,
> effect a delay with a busy loop; an example of such has been posted
> in response to the thread in pgsql-admin, and didn't the regression
> tests do so until recently? That se
Michael Adler wrote:
> On Sun, Aug 21, 2005 at 09:13:20PM -0400, Tom Lane wrote:
> > Michael Fuhr <[EMAIL PROTECTED]> writes:
> > > What do people think of exposing pg_usleep() to the user?
> >
> > I'm not real enthused about it. Generally speaking, a sleep() on the
> > database side means you ar
On Sun, Aug 21, 2005 at 09:13:20PM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > What do people think of exposing pg_usleep() to the user?
>
> I'm not real enthused about it. Generally speaking, a sleep() on the
> database side means you are idling while holding locks, and
On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote:
To others who've written their own sleep() function: what are you
using it for?
I need it for API and user interface testing. I want to be sure
things behave correctly when a long running query is interrupted.
John DeSoi, Ph.D.
http://pg
-Original Message-
From: "Michael Fuhr"<[EMAIL PROTECTED]>
Sent: 22/08/05 05:41:50
To: "Tom Lane"<[EMAIL PROTECTED]>
Cc: "pgsql-hackers@postgresql.org"
Subject: Re: [HACKERS] Sleep functions
> To others who've written their own sleep()
On Sun, Aug 21, 2005 at 09:13:20PM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > What do people think of exposing pg_usleep() to the user?
>
> I'm not real enthused about it. Generally speaking, a sleep() on the
> database side means you are idling while holding locks, and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> As other responders noted, it's trivial to program this in any of the
> untrusted PL languages,
Or in (trusted) plperl - see my post on admin.
I would have been a big fan of a sleep function once, for use in plpgsql,
but since I now have perlperl
Michael Fuhr <[EMAIL PROTECTED]> writes:
> What do people think of exposing pg_usleep() to the user?
I'm not real enthused about it. Generally speaking, a sleep() on the
database side means you are idling while holding locks, and that does
not seem like something we want to encourage people to do
-Original Message-
From: "Michael Fuhr"<[EMAIL PROTECTED]>
Sent: 21/08/05 23:53:50
To: "[EMAIL PROTECTED]"<[EMAIL PROTECTED]>
Subject: [HACKERS] Sleep functions
> What do people think of exposing
> pg_usleep() to the user?
Good idea - I
Michael Fuhr wrote:
What do people think of exposing pg_usleep() to the user? It's
sometimes useful to have a server-side sleep function, and people
do ask about it occasionally (e.g., Don Drake today in pgsql-admin).
It's easy enough to do in PL/Perl, PL/Tcl, etc., but since the
backend alre
What do people think of exposing pg_usleep() to the user? It's
sometimes useful to have a server-side sleep function, and people
do ask about it occasionally (e.g., Don Drake today in pgsql-admin).
It's easy enough to do in PL/Perl, PL/Tcl, etc., but since the
backend already has pg_usleep(), is t
20 matches
Mail list logo
