PL/SQL Function: self-contained transaction?

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема PL/SQL Function: self-contained transaction?
Дата
Msg-id 20050822141357.B1002@ganymede.hub.org
обсуждение исходный текст
Ответы Re: PL/SQL Function: self-contained transaction?  (Greg Stark <gsstark@mit.edu>)
Re: PL/SQL Function: self-contained transaction?  ("A. Kretschmer" <akretschmer@despammed.com>)
Список pgsql-sql
In PostgreSQL, as everyone knows, a QUERY == a transaction, unless wrap'd 
in a BEGIN/END explicitly ... how does that work with a function?  is 
there an implicit BEGIN/END around the whole transaction, or each QUERY 
within the function itself?

If the whole function (and all QUERYs inside of it) are considered one 
transaction, can you do a begin/end within the function itself to 'force' 
commit on a specific part of the function?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: A Table's Primary Key Listing
Следующее
От: Greg Stark
Дата:
Сообщение: Re: PL/SQL Function: self-contained transaction?