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

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

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




Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppgsql-ports @
postedFeb 5, '99 at 8:15p
activeFeb 5, '99 at 8:15p

1 user in discussion

Marc Northover: 1 post



site design / logo © 2022 Grokbase