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


Your name : Marc Northover
Your email address : marc@eni.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:
---------


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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedFeb 5, '99 at 8:15p
activeFeb 5, '99 at 8:15p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Marc Northover: 1 post

People

Translate

site design / logo © 2022 Grokbase