Skip site navigation (1) Skip section navigation (2)

Port Bug Report: backend/utils/adt/cash.c problems

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 (view raw or flat)
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:
---------


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


Responses

pgsql-ports by date

Next:From: Sean BennettDate: 1999-04-15 10:17:59
Subject: Regression Test errors
Previous:From: Unprivileged userDate: 1999-04-14 13:30:36
Subject: Port Bug Report: Web pages has url's leading nowhere

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group