Re: pgsql: Make the pg_stat_activity view call a SRF

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Make the pg_stat_activity view call a SRF
Дата
Msg-id 9487.1210178230@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pgsql: Make the pg_stat_activity view call a SRF  (mha@postgresql.org (Magnus Hagander))
Ответы Re: pgsql: Make the pg_stat_activity view call a SRF  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-committers
Дерево обсуждения 
mha@postgresql.org (Magnus Hagander) writes:
> Make the pg_stat_activity view call a SRF (pg_stat_get_activity())
> instead of calling a bunch of individual functions.

> This function can also be called directly, taking a PID as an argument, to
> return only the data for a single PID.

Hmm, if you really intend the function to be used directly, then having
to provide the output column list for it is a pretty big usability hit.
Why not declare it with OUT parameters, instead?

            regards, tom lane

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

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Move Client Authentication right after Server Configuration in
Следующее
От: achernow@pgfoundry.org (User Achernow)
Дата:
Сообщение: libpqtypes - libpqtypes: enhanced html output from groff2html, fixed