> 2) Access 97 is generating the following SQL statement: 'select
> "orderlines"."orderlinesid" from "orderlines" where (NULL = "orderid")'.
> This fails in PostgreSQL and causes an error in my Access97 application.
> This happens when I try an insert a new record using a form that contains a
> parent child relationship on orders and orderlines. What are others doing
> to work around this problem? One suggested work around was the following
> enhancement to gram.y:
>
> | NULL_P '=' a_expr
> { $$ = makeA_Expr(ISNULL,
> NULL, $3,
> NULL); }
>
> I have made this enhancement to my version 6.4.2 and it solved my
> problem. I would like to see this issue resolved in version 6.5 of
> PostgreSQL?
It is in the 6.5 tree already. It is generating a shift/reduce
conflict, so someone is going to figure out how to fix that.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026