Hi,
Eine stored procedure kann bei PGSQL AFAIK problemlos eine Transaktion sein, also ja.
Hmm? Transaktionen sind aber nicht Atomar...
Transaktionen sind atomar, das ist ihr Sinn. Eine Menge von Befehlen abarbeitungstechnisch zu einem großen zusammenzufassen. Also entweder alle oder keiner. Wenn also das System eine SP als Transaktion auffasst, hast du das gesuchte erreicht.
MfG
Rouven
--
-------------------
Computer programming is tremendous fun. Like music, it is a skill that derives from an unknown blend of innate talent and constant practice. Like drawing, it can be shaped to a variety of ends: commercial, artistic, and pure entertainment. Programmers have a well-deserved reputation for working long hours but are rarely credited with being driven by creative fevers. Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination, but because their imagination reveals worlds that others cannot see. -- Larry OBrien and Bruce Eckel in Thinking in C#
-------------------
Computer programming is tremendous fun. Like music, it is a skill that derives from an unknown blend of innate talent and constant practice. Like drawing, it can be shaped to a variety of ends: commercial, artistic, and pure entertainment. Programmers have a well-deserved reputation for working long hours but are rarely credited with being driven by creative fevers. Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination, but because their imagination reveals worlds that others cannot see. -- Larry OBrien and Bruce Eckel in Thinking in C#