Re: [PATCHES] Updatable views

--On Freitag, September 01, 2006 11:41:16 -0400 Tom Lane
<tgl(at)sss(dot)pgh(dot)pa(dot)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