From:
Michael Fuhr <mike(at)fuhr(dot)org>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject:
Re: Numeric 508 datatype
Date:
2005-12-02 22:04:23
Message-ID:
20051202220423.GA35126@winnie.fuhr.org (view raw or flat )
Thread:
2005-11-16 17:13:49 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-11-17 09:57:01 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2005-11-17 14:26:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-11-17 14:49:10 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2005-11-17 15:57:33 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2005-11-17 16:13:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2005-11-17 16:20:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-11-17 16:59:43 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-11-17 17:48:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-11-18 11:11:09 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2005-11-18 11:32:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2005-11-18 12:07:47 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2005-11-20 17:43:42 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-11-20 20:30:15 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2005-12-02 04:34:00 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 08:57:14 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-12-02 16:47:22 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 17:17:14 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 17:43:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 18:03:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 18:21:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 18:42:40 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 18:54:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 19:09:08 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 19:53:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 20:01:40 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2005-12-02 20:06:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 20:12:00 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2005-12-02 20:14:31 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 20:15:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 20:26:34 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2005-12-02 20:44:11 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 20:55:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 20:59:36 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 21:10:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 21:19:20 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 21:30:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 22:04:23 from Michael Fuhr <mike(at)fuhr(dot)org>
2005-12-02 22:11:13 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 22:20:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 22:23:53 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 22:26:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 22:29:59 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 22:39:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 22:41:34 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 22:49:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 23:38:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-03 04:25:23 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-03 18:07:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-04 01:14:09 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-04 02:17:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-04 02:38:14 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-05 02:50:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-05 03:18:10 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-05 03:27:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-05 04:16:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-05 05:10:35 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-05 05:25:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-02 22:38:17 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 21:01:32 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-12-02 21:05:28 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 17:39:11 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-02 20:37:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-03 00:37:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-03 11:17:46 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2005-12-03 16:43:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-03 21:30:00 from Bruno Wolff III <bruno(at)wolff(dot)to>
2005-12-05 13:24:16 from "John D(dot) Burger" <john(at)mitre(dot)org>
2005-12-05 17:38:17 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-05 18:31:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-05 19:07:27 from Gregory Maxwell <gmaxwell(at)gmail(dot)com>
2005-12-06 04:59:10 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-06 05:51:12 from Michael Fuhr <mike(at)fuhr(dot)org>
2005-12-06 06:02:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-06 13:35:50 from "John D(dot) Burger" <john(at)mitre(dot)org>
2005-12-06 18:20:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-12-06 18:27:49 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-12-12 21:36:41 from "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Lists:
pgsql-general pgsql-hackers pgsql-patches
On Fri, Dec 02, 2005 at 04:30:54PM -0500, Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Wow, check this out:
> > test=> SELECT CAST (pow(10::numeric, 10000) + 1 AS TEXT)
> > It works fine! I have all the digits, and the trailing 1.0:
> > 000001.0000000000000000
> > while SELECT pow(10::numeric, 10000) fails.
>
> That's just about as wacky as can be, because numeric_text() is
> implemented on top of numeric_out() ... there's no way that numeric_out
> can be delivering the wrong answer if the cast produces the right text.
> So somewhere between numeric_out and the delivery to the client,
> something's getting confused. I think it's time you got out your
> debugger and started tracing through the backend ...
Bruce, have you run a process trace on the backend to see if write()
(or whatever) is writing the correct number of characters? What
exactly is your output device and how are you connected to the
machine that runs the backend (ssh to a remote box from an xterm,
sitting in front of the box's VT52 serial console, etc.)?
If you run the query that fails in a standalone backend, do you get
something like "(typeid = 1700, len = -1, typmod = -1, byval = f)"
at the end of the line, or is that part truncated too?
--
Michael Fuhr
In response to
Responses
pgsql-hackers by date
Next :From: Andrew SullivanDate: 2005-12-02 22:07:22Subject : Re: Please let us know if you will come to the PostgreSQL AnniversaryPrevious :From : Tom LaneDate : 2005-12-02 21:30:54Subject : Re: Numeric 508 datatype
pgsql-patches by date
Next :From: Bruce MomjianDate: 2005-12-02 22:11:13Subject : Re: Numeric 508 datatypePrevious :From : Tom LaneDate : 2005-12-02 21:30:54Subject : Re: Numeric 508 datatype
pgsql-general by date
Next :From: Joshua D. DrakeDate: 2005-12-02 22:08:43Subject : Re: was a initdb required from 8.1beta3 -> beta4?Previous :From : Tony CadutoDate : 2005-12-02 22:03:27Subject : was a initdb required from 8.1beta3 -> beta4?
