The following bug has been logged online:

Bug reference: 2148
Logged by: Sokolov Yura
Email address: falcon (AT) intercable (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

On Thu, Jan 05, 2006 at 04:19:23PM +0000, Sokolov Yura wrote:
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 (AT) pervasive (DOT) com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Fri, Jan 06, 2006 at 10:30:28AM -0600, Jim C. Nasby wrote:
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...2/msg00128.php
http://archives.postgresql.org/pgsql...2/msg00296.php
http://archives.postgresql.org/pgsql...2/msg00297.php

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

"Sokolov Yura" <falcon (AT) intercable (DOT) ru> writes:
Works for me ... try a more recent 8.0.* release.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match