Re: Rule trouble (looks to me exactly like the example)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frank Joerdens <frank(at)joerdens(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Rule trouble (looks to me exactly like the example)
Date: 2002-04-05 05:59:49
Message-ID: 22094.1017986389@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Joerdens 2002-04-05 10:08:51 Re: Rule trouble (looks to me exactly like the example)
Previous Message Bruce Momjian 2002-04-05 02:40:02 Re: 16 parameter limit