Re: [HACKERS] BUG: NOT boolfield kills backend

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: redax(at)agria(dot)hu (Zsolt Varga)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] BUG: NOT boolfield kills backend
Date: 1998-09-22 21:21:11
Message-ID: 199809222122.RAA03134@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fixed.

>
> Hi,
> I just found an error in every postgres versions,
> (I tried 6.2.1, 6.3.2, and 6.4beta1 )
>
> if I have a table with boolean field, and I want to negate that field,
> it's kills the backend process... meanwhile 'select not ( 'T'::bool )'
> works well...
>
> create table t1 ( b bool );
> insert into t1 values ( 'T' );
>
> select not b from t1;
> PQexec() -- Request was sent to backend, but backend closed the channel
> before responding.
> This probably means the backend terminated abnormally before or
> while processing the request.
>
> don't you have some idea what to do,?
>
> thanks,
> Redax
> .----------------------------------------------------------.
> |Zsolt Varga | tel/fax: +36 36 422811 |
> | AgriaComputer LTD | email: redax(at)agria(dot)hu |
> | System Administrator | URL: http://www.agria.hu/ |
> `----------------------------------------------------------'
>
>
>

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle | (610) 353-9879(w)
+ If your life is a hard drive, | (610) 853-3000(h)
+ Christ can be your backup. |

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Reifenberger 1998-09-22 21:23:18 Re: [HACKERS] current- crash
Previous Message Bruce Momjian 1998-09-22 21:20:56 Re: [HACKERS] select not b from t1 -- electric fence