Re: [HACKERS] It would be nice if this could be fixed...

Chris, any chance you can send a small reproducable test case for this,
with INSERT's and CREATE table.  Thanks.



> =================================================================
>                         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.
> 
> 


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