Port Bug Report: I get errors when trying to update some sql statements
От | Unprivileged user |
---|---|
Тема | Port Bug Report: I get errors when trying to update some sql statements |
Дата | |
Msg-id | 199902052015.PAA82528@hub.org обсуждение исходный текст |
Список | pgsql-ports |
============================================================================ 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: --------- --------------------------------------------------------------------------
В списке pgsql-ports по дате отправления: