Re: [PORTS] Port Bug Report: backend/utils/adt/cash.c problems

Can you please give me something reproducable, perhaps with a create
table statement and some inserts?


>
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name               : Adam Di Carlo
> Your email address      : adam@onshore.com
>
> Category                : runtime: back-end
> Severity                : serious
>
> Summary: backend/utils/adt/cash.c problems
>
> System Configuration
> --------------------
>   Operating System   : Linux 2.0.36 Debian 2.1
>
>   PostgreSQL version : 6.4.2
>
>   Compiler used      : postgresql 6.4.2-5
>
> Hardware:
> ---------
> Linux burrito 2.0.36 #1 Thu Jan 14 17:02:15 EST 1999 i586 unknown
>
> P120, 64MB RAM
>
> Versions of other tools:
> ------------------------
> (used debian package)
>
> --------------------------------------------------------------------------
>
> Problem Description:
> --------------------
> Two bugs when running cash_in() function on different
> data types, from psql, output below.
>
> --------------------------------------------------------------------------
>
> Test Case:
> ----------
> timesheet=> \d client-old
>
> Table    = client-old
> +----------------------------------+----------------------------------+-------+
> |              Field               |              Type                | Length|
> +----------------------------------+----------------------------------+-------+
> | client_id                        | int4                             |     4 |
> | client_name                      | text                             |   var |
> | default_bill_rate                | float8                           |     8 |
> | default_approved                 | int4                             |     4 |
> +----------------------------------+----------------------------------+-------+
> timesheet=> select client_id, client_name, cash_in(float4out(default_bill_rate)), default_approved from "client-old";
> ERROR:  Bad money external representation (null)
> timesheet=> select client_id, client_name, cash_in(default_bill_rate), default_approved from "client-old";
> Backend message type 0x44 arrived while idle
> Backend message type 0x44 arrived while idle
> We have lost the connection to the backend, so further processing is impossible.  Terminating.
>
>
> --------------------------------------------------------------------------
>
> Solution:
> ---------
>
>
> --------------------------------------------------------------------------
>
>
>


--
  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