Re: how to start a procedure after postgresql started.

On 05/21/11 10:41 PM, Darren Duncan wrote:
> Well, if you can run a stored procedure automatically when Postgres
> starts, that looks like a necessary step to being able to implement an
> entire application inside Postgres.
>
> Starting Postgres is running the application.  The analogy is that
> Postgres is the VM/language interpreter and the stored procedure is
> the script to run.
>
> Now if said stored procedure has access to features that collectively
> let it be computationally complete, including arbitrary user I/O, then
> you're done.

adding a

     psql -d dbname -c "select myfunc()" &

to your postgres service start script would satisfy this....

...but your entire application would be running in a single
transaction.  I don't think thats a good thing.

--
john r pierce                            N 37, W 123
santa cruz ca                         mid-left coast