Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?)
Date
Msg-id 199911302204.WAA11424@linda.lfix.co.uk
Whole thread Raw
In response to Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?)  ("Emils Klotins" <emils@mail.usis.bkc.lv>)
List pgsql-sql
"Emils Klotins" wrote: >The same statement on RedHat 5.2 Linux machine breaks the  >backend: > >[ PostgreSQL 6.5.3 on
i586-pc-linux-gnu,compiled by gcc  >2.7.2.3 ] >=> select case when 3=1 then 'rrr'::text when 3=2 else 5 end; >NOTICE:
Messagefrom PostgreSQL backend: >The Postmaster has informed me that some other backend died abnormally and p
>ossiblycorrupted shared memory.
 

This works OK on current Debian GNU/Linux, unstable distribution.  Perhaps
you need to use the Red Hat 6.1.

--      Vote against SPAM: http://www.politik-digital.de/spam/                ========================================
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver              PGP key from public servers; key
ID32B8FAA1                ========================================    "But grow in grace, and in the knowledge of our
Lord     and Saviour Jesus Christ. To him be glory both now and     for ever. Amen."           II Peter 3:18 
 




pgsql-sql by date:

Previous
From: Zsolt Varga
Date:
Subject: date function questions...
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?)