Re: [GENERAL] Calling ROUND w/o a numeric cast blowing up all connections (9.1)

2013-02-08 Thread Tom Lane
Wells Oliver writes: > Ah, bananas. Someone had created a round(double, integer) function in > public that did some shenanigans. Now I've wasted everyone's time. > Though, I do find it odd that it could cause such a crash, bad function or > no. Well, if it was a misdeclared alias for a C functio

Re: [GENERAL] Calling ROUND w/o a numeric cast blowing up all connections (9.1)

2013-02-08 Thread Wells Oliver
Ah, bananas. Someone had created a round(double, integer) function in public that did some shenanigans. Now I've wasted everyone's time. Though, I do find it odd that it could cause such a crash, bad function or no. On Fri, Feb 8, 2013 at 5:13 PM, Tom Lane wrote: > Wells Oliver writes: > > I

Re: [GENERAL] Calling ROUND w/o a numeric cast blowing up all connections (9.1)

2013-02-08 Thread Tom Lane
Wells Oliver writes: > 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 Huh. Works for me ... > Nothing shows up in the log. Either your logging is broken or you're looking in the wrong log, I th

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

2013-02-08 Thread Wells Oliver
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. Vers