Re: [GENERAL] Regular function

2013-04-01 Thread Yuriy Rusinov
Hello ! One's more question arises. In my function sometimes I have to init random number generator via gsl_rng * r = gsl_rng_alloc (gsl_rng_taus); see http://www.gnu.org/software/gsl/manual/html_node/Random-number-generator-initialization.html, may I keep this generator between connections to da

Re: [GENERAL] Regular function

2013-03-31 Thread ajmcello
unsubscribe On Sat, Mar 30, 2013 at 9:07 PM, Adrian Klaver wrote: > On 03/30/2013 08:42 PM, ajmcello wrote: > >> unsubscribe >> >> > If you want to unsubscribe: > > > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general

Re: [GENERAL] Regular function

2013-03-30 Thread Adrian Klaver
On 03/30/2013 08:42 PM, ajmcello wrote: unsubscribe If you want to unsubscribe: To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] Regular function

2013-03-30 Thread ajmcello
unsubscribe On Fri, Mar 29, 2013 at 10:54 AM, Yuriy Rusinov wrote: > Hello colleagues ! > > I have to write pl/pgsql function that has to be triggered not > before/after insert, but in definite time. Does postgresql allows to do > this ? > > Thanks a lot. > > -- > Best regards, > Sincerely your

Re: [GENERAL] Regular function

2013-03-30 Thread ajmcello
unsubscribe On Fri, Mar 29, 2013 at 10:54 AM, Yuriy Rusinov wrote: > Hello colleagues ! > > I have to write pl/pgsql function that has to be triggered not > before/after insert, but in definite time. Does postgresql allows to do > this ? > > Thanks a lot. > > -- > Best regards, > Sincerely your

Re: [GENERAL] Regular function

2013-03-30 Thread Yuriy Rusinov
Thanks a lot. On Fri, Mar 29, 2013 at 10:22 PM, John R Pierce wrote: > On 3/29/2013 11:13 AM, John R Pierce wrote: > >> there is no 'cron' built into postgresql. >> > > actually, there is pgAgent, which is associated with the pgAdmin package, > this implements a cron-like facility to postgres.

Re: [GENERAL] Regular function

2013-03-29 Thread Michael Paquier
On Sat, Mar 30, 2013 at 3:13 AM, John R Pierce wrote: > On 3/29/2013 10:54 AM, Yuriy Rusinov wrote: > >> I have to write pl/pgsql function that has to be triggered not >> before/after insert, but in definite time. Does postgresql allows to do >> this ? >> > > > there is no 'cron' built into postg

Re: [GENERAL] Regular function

2013-03-29 Thread John R Pierce
On 3/29/2013 11:13 AM, John R Pierce wrote: there is no 'cron' built into postgresql. actually, there is pgAgent, which is associated with the pgAdmin package, this implements a cron-like facility to postgres. http://www.pgadmin.org/docs/1.16/pgagent.html -- john r pierce

Re: [GENERAL] Regular function

2013-03-29 Thread John R Pierce
On 3/29/2013 10:54 AM, Yuriy Rusinov wrote: I have to write pl/pgsql function that has to be triggered not before/after insert, but in definite time. Does postgresql allows to do this ? there is no 'cron' built into postgresql. you could write your function, then have an external cron job

[GENERAL] Regular function

2013-03-29 Thread Yuriy Rusinov
Hello colleagues ! I have to write pl/pgsql function that has to be triggered not before/after insert, but in definite time. Does postgresql allows to do this ? Thanks a lot. -- Best regards, Sincerely yours, Yuriy Rusinov.