Skip site navigation (1) Skip section navigation (2)

Re: Numeric 508 datatype

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Numeric 508 datatype
Date: 2005-12-02 20:14:31
Message-ID: 200512022014.jB2KEVd06958@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Please try Tom's \g test:

	test=> select factorial(4000)
	test-> \g /tmp/x
	test=> \q
	$ wc -c /tmp/x
	   20881 /tmp/x
	
Do you see a number greater than 20881, something like 30000?

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> Tom Lane wrote:
> > Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > > So this is a psql bug?
> > 
> > Not here.  Do you see it?
> 
> Actually, no.  If I cut'n paste the number from psql to
> 
> cat > foo
> <shift> <insert>
> 
> then only 4096 chars are copied.  (Amusingly, I can't add a newline to
> ^D and close the file.  I must delete one char to do that.)
> 
> However if I open vim and paste there, the whole 12000+delta chars are
> copied.
> 
> So it must be a bug in Bruce's procedure I guess ...
> 
> -- 
> Alvaro Herrera                                http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 

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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-12-02 20:15:29
Subject: Re: Numeric 508 datatype
Previous:From: Bruce MomjianDate: 2005-12-02 20:12:15
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?

pgsql-patches by date

Next:From: Tom LaneDate: 2005-12-02 20:15:29
Subject: Re: Numeric 508 datatype
Previous:From: Bruce MomjianDate: 2005-12-02 20:12:15
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?

pgsql-general by date

Next:From: Tom LaneDate: 2005-12-02 20:15:29
Subject: Re: Numeric 508 datatype
Previous:From: Alvaro HerreraDate: 2005-12-02 20:12:00
Subject: Re: Numeric 508 datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group