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
