Re: how to start a procedure after postgresql started.

Поиск
Список
Период
Сортировка
От jun yang
Тема Re: how to start a procedure after postgresql started.
Дата
Msg-id BANLkTin-1P2mLd2A_n2r-7rMGKOB6MndPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to start a procedure after postgresql started.  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: how to start a procedure after postgresql started.
Список pgsql-general
2011/5/22 Scott Marlowe <scott.marlowe@gmail.com>:
> On Sat, May 21, 2011 at 10:57 PM, jun yang <slickqt@gmail.com> wrote:
>> now all the question:
>> 1.how start a procedure or a script after postgresql start.
>
> Do you need this stored procedure or script to always run at pg
> database start?  Or every time a client connects to the database?  Or
> every  minute, or every hour or every day?
i am just want pg execute the given stored procedure every time after
pg sucess start.
>
>> 2.how to get notify when a table created.
>> 3.how to get notify when a database created.
>
> Set db to log all dll, scrape logs, email timestamp from table or db
> creation.  Do you need more info other than just that it was created?
>
well,it may be not what i want,
if i can start a procedure after pg start,then i would like to get
notify when new object create,of course,i should be subcribe first.
now what i interest is the database created, when a new database
created,i want to init some schme and table,index in the it.

В списке pgsql-general по дате отправления:

Предыдущее
От: jun yang
Дата:
Сообщение: Re: how to start a procedure after postgresql started.
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)