Updating multiple bool values crashes backend

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Updating multiple bool values crashes backend
Date: 2000-10-24 12:58:59
Message-ID: 200010241258.e9OCwxl33102@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Sean Kelly (S(dot)Kelly(at)ncl(dot)ac(dot)uk) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Updating multiple bool values crashes backend

Long Description
Bug best described by an example, see below.

Tested on two systems:
Intel Pentium III 600
128Mb RAM
Linux 2.2.17

AMD K6 350
96Mb RAM
Linux 2.2.16

both PostgreSQL 7.0.2

Sample Code
users=> select username,added from users_tbl where username like 'neta%';
username | added
----------+-------
neta1 | f
neta2 | f
neta3 | f
neta4 | f
(4 rows)

users=> update users_tbl set added=TRUE where username like 'neta%';
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>\q

bash$ tail ~postgres/server.log
Server process (pid 23747) exited with status 11 at Tue Oct 24 13:52:29 2000
Terminating any active server processes...
Server processes were terminated at Tue Oct 24 13:52:29 2000
Reinitializing shared memory and semaphores
The Data Base System is starting up
DEBUG: Data Base System is starting up at Tue Oct 24 13:52:29 2000
DEBUG: Data Base System was interrupted being in production at Tue Oct 24 13:51:22 2000
DEBUG: Data Base System is in production state at Tue Oct 24 13:52:29 2000

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Holger Klawitter 2000-10-24 16:01:50 Restrictions on columns are not being passed to children tables.
Previous Message Karel Zak 2000-10-24 08:05:17 Re: bug in to_char(timestamp, text) for times between 12:00 and 14:00