Re: FW: query problem "server sent binary data ... without

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <jonesbl(at)WellsFargo(dot)COM>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: FW: query problem "server sent binary data ... without
Date: 2002-09-26 23:01:53
Message-ID: 20020926160003.H30444-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 26 Sep 2002 jonesbl(at)WellsFargo(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris 2002-09-26 23:14:04 Re: Case Sensitive "WHERE" Clauses?
Previous Message Ian Barwick 2002-09-26 23:00:14 Re: Case Sensitive "WHERE" Clauses?