Where are on updatable views?
---------------------------------------------------------------------------
Bernd Helmle wrote:
> --On Freitag, September 01, 2006 11:41:16 -0400 Tom Lane
> <tgl@sss.pgh.pa.us> wrote:
>
> >
> > So in other words, views on serial columns don't work? I don't think
> > that's going to be acceptable.
> >
>
> They work in such a case that someone isn't allowed to put a volatile
> function in an update query....
>
> >
> > Not really worse than what the rewriter is doing already --- in fact,
> > I think it's isomorphic to what would happen to the rule qual
> > expressions in your existing patch.
> >
>
> Currently you don't have to rewrite the rule conditions itself every
> time you apply them to the query tree since they are stored in pg_rewrite
> matching all various (reversed) varattno's, resno's and whatever.
> If i understand correctly you need to do that with constraints every time
> you fire an update query on a view for each underlying relation....
>
> >
> > I'm about to propose that we should try to go beta next week (see
> > forthcoming message). If you can strip down your patch to avoid the
> > multi-eval problems in the next couple of days, I'm still willing to
>
> Depends on how many days "couple of days" are.....if you mean the next
> three days
> then definitely not, since i'm afk for the whole upcoming weekend. Bad
> timing, but
> it's not deferrable.... :(
>
> > consider it, but at the moment I'm assuming that it needs to be held
> > for 8.3.
>
> Well, i'll see what i can do next week....it's a little bit disappointing
> that these problems
> raises so late, but that's no one's fault since there are many side effects
> of the rewriting
> system involved....
>
> Many thanks for your comments.
>
> Bernd
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
