BUG #2148: Crashes on simple statement

On Thu, Jan 05, 2006 at 04:19:23PM +0000, Sokolov Yura wrote:

The following bug has been logged online:

Bug reference: 2148
Logged by: Sokolov Yura
Email address: falcon@intercable.ru
PostgreSQL version: 8.0
Operating system: Slackware Linux 2.6.14.1
Description: Crashes on simple statement
Details:

select ms from (select 1) ms

OS X, Version 8.1.1:
decibel=# select ms from (select 1) ms;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

The backend didn't actually crash, though.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

On Fri, Jan 06, 2006 at 10:30:28AM -0600, Jim C. Nasby wrote:

OS X, Version 8.1.1:
decibel=# select ms from (select 1) ms;
server closed the connection unexpectedly

This query doesn't crash for me with the latest CVS. It might be
the same problem Tom fixed a few weeks ago:

http://archives.postgresql.org/pgsql-bugs/2005-12/msg00128.php
http://archives.postgresql.org/pgsql-committers/2005-12/msg00296.php
http://archives.postgresql.org/pgsql-committers/2005-12/msg00297.php

--
Michael Fuhr

"Sokolov Yura" <falcon@intercable.ru> writes:

select ms from (select 1) ms

Works for me ... try a more recent 8.0.* release.

regards, tom lane