From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | Port Bug Report: backend/utils/adt/cash.c problems |
Date: | 1999-04-14 19:49:04 |
Message-ID: | 199904141949.PAA49534@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
============================================================================
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:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Bennett | 1999-04-15 10:17:59 | Regression Test errors |
Previous Message | Unprivileged user | 1999-04-14 13:30:36 | Port Bug Report: Web pages has url's leading nowhere |