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

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Adam Di Carlo
Your email address : adam(at)onshore(dot)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:
---------

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

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(at)onshore(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026