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(at)tech(dot)com(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026