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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
