Calling ROUND w/o a numeric cast blowing up all connections (9.1)

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Calling ROUND w/o a numeric cast blowing up all connections (9.1)
Date: 2013-02-09 00:38:27
Message-ID: CAOC+FBV-iYpTevJqLJFj=LzeO6meR3N67ir0ddY-VBbY70t0aw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I don't know why this is happening, but it's infuriating. From the psql
prompt:

mydb=# select round(5/2, 1);
SSL SYSCALL error: EOF detected
The connection to the server was lost. Attempting reset: Failed.

This kills any connection to the database. Doing 'round(5/2::numeric, 1)'
works fine.

Version: PostgreSQL 9.1.7 on x86_64-unknown-linux-gnu, compiled by
gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bit

Nothing shows up in the log.

Have I broken my cast function? My round function? Have I angered the RDMS
gods? Can anyone give me any pointers?

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-02-09 01:13:12 Re: Calling ROUND w/o a numeric cast blowing up all connections (9.1)
Previous Message Ben Madin 2013-02-09 00:17:26 Re: Restoring a database dump from 9.0 to 9.2