Micah Yoder wrote:
> I was also thinking a bit more broad than just finance. Could PG be used, for
> example, as a multiplayer strategy game server where clients can directly
> connect without another middleware daemon? Seems to me like it has
> everything necessary, except for this problem.
Each software serves certain purposes.
Databases provide fast, reliable, consistent, and concurrent storage
and retrieval of data.
That's all they try to accomplish.
If you want something else, you'll have to use different software.
You are dreaming of "the one program that does everything".
This animal only exists in marketing brochures. Fortunately.
>> You cannot manage transactions inside functions. A function always
>> runs inside a single transaction.
>
> Actually from the pl/pgsql manual it looks like you can raise an error and
> have it abort the surrounding transaction. If that's true it should be
> robust.
It is - once the transaction is aborted due to an error it will remain in
that state until you terminate the transaction (implicitly or explicitly).
Actually, exception *handling* is implemented using savepoints, so you
could say that one can do limited transaction management inside a function.
But you cannot start or end a transaction inside a function.
Yours,
Laurenz Albe