--On Freitag, September 01, 2006 11:41:16 -0400 Tom Lane <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to