Postgres Pro
Downloads
Home   >   mailing lists

Re: Rule trouble (looks to me exactly like the example) - Mailing list pgsql-sql

From Tom Lane
Subject Re: Rule trouble (looks to me exactly like the example)
Date
Msg-id 22094.1017986389@sss.pgh.pa.us
Whole thread Raw
In response to Re: Rule trouble (looks to me exactly like the example)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
I wrote:
> What's happening is that "new.id" is effectively still NULL at the point
> where the rule is processed, so the rule WHERE condition fails.  I'm not
> sure why you're bothering with that WHERE condition anyway ... but this
> seems to be another argument for moving INSERT's default-value-insertion
> step to before the rule rewriter.

I've committed fixes for this into CVS tip.
        regards, tom lane

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 16 parameter limit
Next
From: Frank Joerdens
Date:
Subject: Re: Rule trouble (looks to me exactly like the example)