Обсуждение: Stored procedure in PostgreSQL

I would like to start stored procedure (function) at specific time and
repeate stored procedure every day.
Is it posible in PostgreSQl?

Thanks.

----- Original Message -----
From: "Robert" <rrozboril@goldmann.sk>


> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?
>

what about writing a script that will be executed by crond every day?

the script should contain something like:

su -l postgres -c "psql -d DBNAME -c \"select * from ..... \"  "


hth,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

On Wed, 2002-03-06 at 10:37, Robert wrote:
> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?
How about :

    "psql -c \"SELECT my_func()\""

in your crontab ?

/BL

Le Mercredi 6 Mars 2002 10:37, Robert a écrit :
> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?

Run batch scripts (Windows) or cron jobs (Linux) excuting:
"psql databasename "SELECT function_foo()"
or "psql databasename < filename.sql"

Best regards,
Jean-Michel POURE

Basically you would use your operating-systems cron (or equivalent)
system.

1.    Setup a query that executes the function, put it in a file;
2.    add something like this to your crontab:
10 03 * * * /path-to-psql/psql < the-file-from-step-1
this would execute your at 10 minutes past 3 (in the morning), every day
(*) of every month (*) regardless of the weekday (*).

Read up on man crontab for more info.

Success,
Arian.

Robert schreef:

> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?
>
> Thanks.