From: Enrico Weigelt <weigelt@metux.de>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: trigger/rule question
Date: Mon, 2 May 2005 05:41:00 +0200
Message-ID: <20050502034100.GE24546@nibiru.borg.metux.de> (raw)
In-Reply-To: <4270AC4F.6D62C9C8@rodos.fzk.de>
References: <20050427165624.GA4253@nibiru.borg.metux.de>
<4270AC4F.6D62C9C8@rodos.fzk.de>
* Christoph Haller <ch@rodos.fzk.de> wrote:
Hi,
> I assume this still refers to
> [SQL] RULE for mtime recording
> from last Friday.
ehm, yeah. I forgot that I've already asked this stuff ...
hmmpf. seems I'm not getting younger ;-)
<snip>
> I gave it another thought and
> I am now having something which seems to work.
> The trick is interpose a view to avoid the
> rule recursion:
<big_snip />
correct me if I'm wrong:
you dont let the application write to the actual storage table, but
instead to a view, which a modified write to the actual storage, where
also the reads get their data from.
okay, that's really an idea worth to think about :)
insert should work the same way. but how to implement delete ?
(the application should only see one table, so in our case the view).
if we user "DO INSTEAD", we wont get anything to delete (AFAIK), so
we cannot intercept here. the only chance seems to leave out "INSTEAD"
and live with duplicate data.
Did I miss anyting ?
cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact@metux.de
---------------------------------------------------------------------
Realtime Forex/Stock Exchange trading powered by postgresSQL :))
http://www.fxignal.net/
---------------------------------------------------------------------
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: weigelt@metux.de
Subject: Re: trigger/rule question
In-Reply-To: <20050502034100.GE24546@nibiru.borg.metux.de>
* 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