Pavel Stehule wrote:
> Hello
>
> 2011/5/22 jun yang <slickqt@gmail.com>:
>> now all the question:
>> 1.how start a procedure or a script after postgresql start.
>> 2.how to get notify when a table created.
>> 3.how to get notify when a database created.
>
> Probably it isn't possible with Pg 9.0 and older. Maybe it is possible
> with callbacks for SE-Linux support in 9.1, but you have to write
> module in C.
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.
-- Darren Duncan