Thread: ...

...

From
"Billy G. Allie"
Date:
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Billy G. Allie
Your email address    :    Bill.Allie@mug.org


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Pentium

  Operating System (example: Linux 2.0.26 ELF)     : UnixWare 7.0.1

  PostgreSQL version (example: PostgreSQL-6.4)  : Current CVS version

  Compiler used (example:  gcc 2.8.0)        : Optimizing C Compilation
                          System  (CCS) 3.2  08/18/98
                          (u701)

Please enter a FULL description of your problem:
------------------------------------------------
src/backend/utils/adt/numeric.c    fails to compile due to a string having an
embedded new-line character.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Compile the program. :-)


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Apply the following patch:

------------------------------ 8< CUT HERE >8 ------------------------------
*** src/backend/utils/adt/numeric.c.orig    Mon Mar  1 10:13:27 1999
--- src/backend/utils/adt/numeric.c    Mon Mar  1 23:09:00 1999
***************
*** 2370,2377 ****
      if (var->weight >= maxweight)
      {
          free_allvars();
!         elog(ERROR, "overflow on numeric
!         ABS(value) >= 10^%d for field with precision %d scale %d",
                              var->weight, precision, scale);
      }

--- 2370,2377 ----
      if (var->weight >= maxweight)
      {
          free_allvars();
!         elog(ERROR, "overflow on numeric "
!         "ABS(value) >= 10^%d for field with precision %d scale %d",
                              var->weight, precision, scale);
      }

------------------------------ 8< CUT HERE >8 ------------------------------

____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    |

Attachment

Re: your mail

From
Bruce Momjian
Date:
Applied.


>
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name        :    Billy G. Allie
> Your email address    :    Bill.Allie@mug.org
>
>
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)      : Pentium
>
>   Operating System (example: Linux 2.0.26 ELF)     : UnixWare 7.0.1
>
>   PostgreSQL version (example: PostgreSQL-6.4)  : Current CVS version
>
>   Compiler used (example:  gcc 2.8.0)        : Optimizing C Compilation
>                           System  (CCS) 3.2  08/18/98
>                           (u701)
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
> src/backend/utils/adt/numeric.c    fails to compile due to a string having an
> embedded new-line character.
>
>
> Please describe a way to repeat the problem.   Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
> Compile the program. :-)
>
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
> Apply the following patch:
>
> ------------------------------ 8< CUT HERE >8 ------------------------------
> *** src/backend/utils/adt/numeric.c.orig    Mon Mar  1 10:13:27 1999
> --- src/backend/utils/adt/numeric.c    Mon Mar  1 23:09:00 1999
> ***************
> *** 2370,2377 ****
>       if (var->weight >= maxweight)
>       {
>           free_allvars();
> !         elog(ERROR, "overflow on numeric
> !         ABS(value) >= 10^%d for field with precision %d scale %d",
>                               var->weight, precision, scale);
>       }
>
> --- 2370,2377 ----
>       if (var->weight >= maxweight)
>       {
>           free_allvars();
> !         elog(ERROR, "overflow on numeric "
> !         "ABS(value) >= 10^%d for field with precision %d scale %d",
>                               var->weight, precision, scale);
>       }
>
> ------------------------------ 8< CUT HERE >8 ------------------------------
>
Content-Description: uw7.patch

[Attachment, skipping...]

> ____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
> |  /|      | 7436 Hartwell     | Compuserve: 76337,2061
> |-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
> |/  |LLIE  | (313) 582-1540    |

[application/pgp-signature is not supported, skipping...]


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026