Re: [HACKERS] It would be nice if this could be fixed... - Mailing list pgsql-hackers

=================================================================                       POSTGRESQL BUG REPORT TEMPLATE
=================================================================


Your name       : Chris Bitmead    
Your email address  : chris@tech.com.au


System Configuration
--------------------- Architecture   : Intel x86
 Operating System  : Linux 2.0.36
 PostgreSQL version  :  Latest Snapshot as at May 2, 1999
 Compiler used      : gcc 2.7.2.3


Please enter a FULL description of your problem:
------------------------------------------------

COALESCE sql function causes postgres to CRASH!

e.g.

SELECT story.title,story.image, mfr.image FROM story, mfr where
story.category= mfr.oid;
title         |image             |image               
--------------+------------------+--------------------
Canon         |/icon/critique.jpg|/icon/canon.gif     
Nikon         |                  |/icon/nikon.gif     
Olympus       |                  |/icon/olympus.gif   
New Arca      |                  |/icon/arca-swiss.gif
New Hasselblad|                  |/icon/hasselblad.gif
(5 rows)

httpd=> SELECT story.title, COALESCE(story.image, mfr.image) FROM story,
mfr where story.category= mfr.oid;
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.