Re: pgsql: Changed TODO wording: < * Support procedures, which return no

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pgsql: Changed TODO wording: < * Support procedures, which return no
Дата
Msg-id 200804111951.m3BJp4e10494@momjian.us
обсуждение исходный текст
Ответ на Re: pgsql: Changed TODO wording: < * Support procedures, which return no  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Tom Lane wrote:
> momjian@postgresql.org (Bruce Momjian) writes:
> > Log Message:
> > -----------
> > Changed TODO wording:
>
> > < * Support procedures, which return no value
> > > * Allow functions to control the transaction state
>
> I can't imagine that we'd implement this by "allowing functions to
> control the transaction state".  It would have to be some other sort
> of object that is invoked in some entirely other way, perhaps
> via a "PERFORM procedure_name..." kind of command.  Once you're inside
> a SELECT you're not going to be committing anything.

OK, updated wording:

    * Allow calling of a procedure outside a SELECT that can control the
      transaction state

I see now why a transaction is needed --- because it doesn't have the
SELECT wrapper.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Update wording: < * Allow functions to control the transaction
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Fix several datatype input functions that were allowing unused