Re: thousands comma numeric formatting in psql - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: thousands comma numeric formatting in psql
Date
Msg-id 200507151821.j6FILM722022@candle.pha.pa.us
Whole thread Raw
In response to Re: thousands comma numeric formatting in psql  (Eugen Nedelcu <eugen@sifolt.ro>)
Responses Re: thousands comma numeric formatting in psql  (Eugen Nedelcu <eugen@sifolt.ro>)
List pgsql-patches
Eugen Nedelcu wrote:
> The new code is broken. Please test it with resonably large tables.
> Do not test it with querys like: select -132323435.34343;
>
> If I use a query like:
>
> select * from my_table limit 100;
>
> I can't see anything on my screen until I hit CTRL^C
>
> If I use a pager (\pset pager less) strange things happened:
> I can't see anything on my screen, hit CTRL^C, then quit psql,
> reset xterm, then less is still running and eat lots of memory and
> cpu.

I did:

    SELECT random() * 1000000000 INTO test
    FROM generate_series(1,100000);
    \pset numericsep
    SELECT * FROM test;

and it seemed to work fine.  Did you do a complete rebuild/install?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Chris Browne
Date:
Subject: AIX FAQ Updates
Next
From: Stephen Frost
Date:
Subject: Re: Change Ownership Permission Checks