On Friday 28 May 2004 04:08 pm, pgsql(at)mohawksoft(dot)com wrote:
>
> No transactions.
>
Then it won't work. Let's say we take your example. The variable "s" is
supposed to be the sum of a column in a table.
When someone modifies the data in the table, when is "s" adjusted? What if
it is modified but the transaction is aborted? Who sees the "correct" value
of "s" at any point in time?
--
Jonathan Gardner
jgardner(at)jonathangardner(dot)net