| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: deleting rows in specific order |
| Date: | 2006-10-16 17:51:10 |
| Message-ID: | 20061016175110.GA15534@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Oct 11, 2006 at 21:31:37 +0200,
Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chrisj | 2006-10-17 03:27:42 | Re: Assigning a timestamp without timezone to a timestamp |
| Previous Message | Marc G. Fournier | 2006-10-16 17:25:31 | Re: get_next_billing_date() ... |