> > The attached commands crash the backend, which exits with status 11.
>
> tgl=> select * from x where not (i is null or c is null);
> i|c
> -+-
> 1|T
> 2|A
> 0|T
> (3 rows)
>
> tgl=> select * from x where not (i is null and c is null);
> pqReadData() -- backend closed the channel unexpectedly.
>
> So, let's try rewriting it as a workaround:
>
> tgl=> select * from x where (not i is null) or (not c is null);
> pqReadData() -- backend closed the channel unexpectedly.
>
> Oops. For some reason the NOT/AND is fatal, while NOT/OR is OK. That's
> not so good. The good news is that it will certainly be repairable with
> patches.
>
Care to give us a table:
select * from pg_shadow where (usesysid is null and oid is null)\g
-- 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