Helo,
On Tue, 2 Nov 2004 13:05:07 +0100
Markus Schaber <schabios@logi-track.com> wrote:
> -- But to remain compatibility with old apps, we also need to manage
> -- updates to the view, which are to be rewritten as follows:
> CREATE RULE testview_update_rule
> AS ON UPDATE TO testview DO INSTEAD
> UPDATE realdata SET
> index = NEW.index,
> data = NEW.data,
> obsolete=NULL
> ;
I now got it to work with adding a "WHERE index=NEW.index" to the view.
Am I correct in my assumption that this means that this only works when
I have a primary key (or at least unique) row in my dataset?
Thanks,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com