min() and max() causing aborts

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: min() and max() causing aborts
Date: 1999-03-20 07:08:33
Message-ID: 93C04F1F5173D211A27900105AA8FCFC1452A8@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I pulled the latest version of the source tree yesterday and complied
PosgtreSQL 6.5. The get the following error on any select statement
containing min() and max():

mp=> select max(addressid) from addresses;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or
while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

I am running Red Hat 5.1.

FYI, I also noticed failures in the regressions tests for int2 and int4 and
some others (int8 was okay). I did not dig very deep into this but the only
error I could see with int2 and int4 occurred when the value that was being
inserted into the table was too large for the field. For example, inserting
100000 into an int2 field.

Thanks, Michael

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-03-20 12:41:03 Re: [HACKERS] min() and max() causing aborts
Previous Message Bruce Momjian 1999-03-20 04:15:28 Re: [HACKERS] One more globe