Sean Kelly (S.Kelly@ncl.ac.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
