Re: [HACKERS] Sheduling in SQL

2001-03-15 Thread Vincent AE Scott
On Thu, 15 Mar 2001, Paul wrote: > Sorry, if I used not corresponding mailing list, but I really dont > know where to send such email. > > Is that possible to add one more SQL command to Postgres? The problem > that IMHO no one RDBMS allows SQL command for sheduling. To support > sheduling SQL p

Re: [HACKERS] Sheduling in SQL

2001-03-15 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> (some of the protocol changes in 6.4 were done to make it easier ;-)). > I may misremember, but IIRC some older protocol (or at least libpq) > returned 0 as backend pid to listening client if it was notified by itself. > Currently i

Re: [HACKERS] Sheduling in SQL

2001-03-15 Thread Hannu Krosing
Tom Lane wrote: > > I've built applications that do roughly this sort of thing in Postgres > (some of the protocol changes in 6.4 were done to make it easier ;-)). I may misremember, but IIRC some older protocol (or at least libpq) returned 0 as backend pid to listening client if it was notifi

Re: [HACKERS] Sheduling in SQL

2001-03-15 Thread Tom Lane
Paul <[EMAIL PROTECTED]> writes: > CREATE SHEDULER name > ON table.field > [FOR [EACH]|[LAST]] > EXECUTE PROCEDURE func(arguments) > When the current time becomes equal or more than minimal time in > the _table.field_, the event happens and the _func_ will be executed, > and after that all record

[HACKERS] Sheduling in SQL

2001-03-15 Thread Paul
Sorry, if I used not corresponding mailing list, but I really dont know where to send such email. Is that possible to add one more SQL command to Postgres? The problem that IMHO no one RDBMS allows SQL command for sheduling. To support sheduling SQL programmers have to use outer tools to periodic