From: Bruno Wolff III <bruno@wolff.to>
To: Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: deleting rows in specific order
Date: Mon, 16 Oct 2006 12:51:10 -0500
Message-ID: <20061016175110.GA15534@wolff.to> (raw)
In-Reply-To: <Pine.LNX.4.61.0610112108100.16984@mazsola.iit.uni-miskolc.hu>
References: <Pine.LNX.4.61.0610092207210.24332@mazsola.iit.uni-miskolc.hu>
<452CE81A.5010001@logix-tt.com>
<Pine.LNX.4.61.0610112108100.16984@mazsola.iit.uni-miskolc.hu>
On Wed, Oct 11, 2006 at 21:31:37 +0200,
Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu> wrote:
> On Wed, 11 Oct 2006, Markus Schaber wrote:
>
> After inserting new rows into this table, very old rows are going to
> be deleted. But value of deleted info should be remembered somehow, so
> there is a trigger on delete which keeps sum of the deleted info
> values in a separate table. This makes the application happy.
You need to be careful if two of these can run at the same time if you
are adding the values to prexisting sums otherwise you might end up summing
just the values from one of the delete sets.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, drdani@mazsola.iit.uni-miskolc.hu
Subject: Re: deleting rows in specific order
In-Reply-To: <20061016175110.GA15534@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox