Re: FW: query problem "server sent binary data ... without - Mailing list pgsql-sql

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.