Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4FC0E476D90
	for <pgsql-sql@postgresql.org>; Thu, 26 Sep 2002 19:01:53 -0400 (EDT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178])
	by postgresql.org (Postfix) with ESMTP id D2EFB476D83
	for <pgsql-sql@postgresql.org>; Thu, 26 Sep 2002 19:01:52 -0400 (EDT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 3889CD627; Thu, 26 Sep 2002 16:01:54 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 1C1245C02; Thu, 26 Sep 2002 16:01:54 -0700 (PDT)
Date: Thu, 26 Sep 2002 16:01:53 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: <jonesbl@WellsFargo.COM>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: FW: query problem "server sent binary data ... without
In-Reply-To: 
 <5BA4EAE4ACF6D211BC540001FA7EB1960AE53AFA@xcem-casfo-11.wellsfargo.com>
Message-ID: <20020926160003.H30444-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/345
X-Sequence-Number: 9622

On Thu, 26 Sep 2002 jonesbl@WellsFargo.COM wrote:

> 		I'm having a problem with postgres on HPUX. My version is:
>
> 		VERSION = 'PostgreSQL 7.2.2 on hppa2.0w-hp-hpux11.11,
> compiled by aCC -Ae'
>
> 		I'm trying to do a query and it consistently gives the
> following errors:
>
> 		wily=# \a
> 		Output format is unaligned.
> 		wily=# \f ';'
> 		Field separator is ';'.
> 		wily=# \t
> 		Showing only tuples.
>
> 		wily=# select * from wt_metric_backup where intended_end_ts
> < '2002-08-16 00:00:00.000-7';
>
> 		the query runs for 10 minutes or so, then outputs:

How much data is that sending?  The client library is going to try to
buffer the entire result set.