From: Mike Meyer <mwm@mired.org>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Rule for updating through a view.
Date: Mon, 24 Mar 2003 11:31:45 -0600
Message-ID: <15999.16641.828710.981313@guru.mired.org> (raw)
In-Reply-To: <3E7F2C01.E012A174@rodos.fzk.de>
References: <3E7F2C01.E012A174@rodos.fzk.de>
In <3E7F2C01.E012A174@rodos.fzk.de>, Christoph Haller <ch@rodos.fzk.de> typed:
> Is it this what you've found and can't get to work?
Yes, that was what I found. I was having trouble figuring out how it
*should* work. I think I've got it now - the missing idea was that the
new and old rows contain the *entire* rows, not just what was being
updated. That makes it possible to pull values from them and udpate
entire rows in the table(s) the view joins. At least, that's the way I
believe it should work. My views don't have enough information to
identify a unique row in those tables, so I can't do this safely
anyway.
Thanks,
<mike
--
Mike Meyer <mwm@mired.org> http://www.mired.org/consulting.html
Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.
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: mwm@mired.org, ch@rodos.fzk.de
Subject: Re: Rule for updating through a view.
In-Reply-To: <15999.16641.828710.981313@guru.mired.org>
* 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