Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA02310; Tue, 2 Feb 93 08:42:43 -0800
Date: Tue, 2 Feb 93 08:42:43 -0800
Message-Id: <9302021642.AA02310@postgres.Berkeley.EDU>
From: neve@nlm.nih.gov (Leif Neve)
Subject: Aggregates don't work with "postmaster -d"
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

Folks,

When I run the postmaster with the "-d" flag, aggregates
no longer work. Queries involving aggregates just hang.

The debug output from the postmaster says:

  started '/usr/local/postgres/bin/postgres' for 'neve' on 'srw' (4) pid (16933)
  In reaper
  In CleanUpProc - Backend with pid 16933 exited with status 11

When I run the same query after starting up the postmaster without
the -d flag, everything works fine. I've tried a number of aggregate
functions (e.g. int2max, int4max, int2ave, int4ave) and they all fail.

Anyone seen this problem?

Leif Neve