FAQ
============================================================================
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:
---------


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

Search Discussions

  • Bruce Momjian at May 10, 1999 at 3:33 pm
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedApr 14, '99 at 7:49p
activeMay 10, '99 at 3:33p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Adam Di Carlo: 1 post Bruce Momjian: 1 post

People

Translate

site design / logo © 2022 Grokbase