Port Bug Report: I get errors when trying to update some sql statements

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: I get errors when trying to update some sql statements
Date: 1999-02-05 20:15:00
Message-ID: 199902052015.PAA82528@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


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

Your name : Marc Northover
Your email address : marc(at)eni(dot)net

Category : runtime: back-end: SQL
Severity : critical

Summary: I get errors when trying to update some sql statements

System Configuration
--------------------
Operating System : Linux 2.0.35

PostgreSQL version : 6.4.2

Compiler used : gcc version 2.7.2.3

Hardware:
---------
Linux moink 2.0.35 #1 Tue Jul 14 23:56:39 EDT 1998 i586 unknown
Pentium, 64MB Ram

Versions of other tools:
------------------------

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

Problem Description:
--------------------
If I try to update certain rows in my database I get
the following error. I can select the info with no
problem

info=> UPDATE info SET last_updated = 'now', reviewed = 'TRUE' WHERE seq = 65;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.

here is the table structure:
info=> \d info

Table = info
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| seq | int4 not null | 4 |
| text | varchar() not null | 4096 |
| created | timestamp not null | 4 |
| last_updated | timestamp not null | 4 |
| entered_by | int4 | 4 |
| reviewed | bool not null | 1 |
| times_read | int4 not null | 4 |
+----------------------------------+----------------------------------+-------+
Indices: info_seq_pk
info_text_uk

info=> select * from info where seq = 65;
seq|text |created |last_updated |entered_by|reviewed|times_read
---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+----------+--------+----------
65|A man was walking along a California beach and stumbled across an old lamp.
He picked it up and rubbed it and out popped a genie.

The genie said "OK, OK. You released me from the lamp, blah blah blah. This
is the fourth time this month and I'm getting a little sick of these wishes
so you can forget about three. You only get one wish!" The man sat and
thought about it for a while and said, "I've always wanted to go to Hawaii
but I'm scared to fly and I get very seasick.

Could you build me a bridge to Hawaii so I can drive over there to visit?"

The genie laughed and said, "That's impossible. Think of the logistics of
that! How would the supports ever reach the bottom of the Pacific? Think of
how much concrete...how much steel!! No-think of another wish."

The man said OK and tried to think of a really good wish. Finally, he said,
"I've been married and divorced four times. My wives always said that I
don't care and that I'm insensitive. So, I wish that I could understand
women....know how they feel inside and what they're thinking when they give
me the silent treatment....know why they're crying, know what they really
want when they say 'nothing'....know how to make them truly happy...."

The genie said, "You want that bridge two lanes or four?"|1999-01-28 11:17:49-08|1999-01-28 11:17:49-08| 7|f | 3
(1 row)

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

Test Case:
----------

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

Solution:
---------

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

Browse pgsql-ports by date

  From Date Subject
Next Message Diana Eichert 1999-02-05 22:57:15 6.4.2 regression test lockup under OpenBSD 2.4
Previous Message Thomas G. Lockhart 1999-02-05 17:04:12 Re: [PORTS] Port Bug Report: