[HACKERS] COALESCE bug

2005-10-10 Thread Daniel Schuchardt
Hy, my PostgreSQL 8.0.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 crashes when SELECT * FROM pg_stat_activity WHERE datname=COALESCE(NULL, NULL); I had an mistake in a stored procedure so COALESCE got 2 NULL values but a crash is not nice here ;-) workaround : SELECT * FROM

Re: [HACKERS] COALESCE bug

2005-10-10 Thread Michael Fuhr
On Mon, Oct 10, 2005 at 03:56:10PM +0200, Daniel Schuchardt wrote: my PostgreSQL 8.0.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 crashes when SELECT * FROM pg_stat_activity WHERE datname=COALESCE(NULL, NULL); Already reported and fixed as of 8.0.3; consider upgrading (8.0.4