Skip site navigation (1) Skip section navigation (2)

Re: Extended customizing, SQL functions,

From: pgsql(at)mohawksoft(dot)com
To: "Jonathan Gardner" <jgardner(at)jonathangardner(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extended customizing, SQL functions,
Date: 2004-05-29 03:54:37
Message-ID: 16595.24.91.171.78.1085802877.squirrel@mail.mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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?

Like I said, it is a *bad* idea. No one is denying this, it "breaks" all
the rules, but "with care" I can see a limited, but valuable function.

>
> --
> Jonathan Gardner
> jgardner(at)jonathangardner(dot)net
>


In response to

pgsql-hackers by date

Next:From: Matthew T. O'ConnorDate: 2004-05-29 04:17:52
Subject: Re: temp tables broken in CVS HEAD?
Previous:From: Alvaro HerreraDate: 2004-05-29 03:35:49
Subject: Re: temp tables broken in CVS HEAD?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group