Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id QAA11926; Thu, 22 Apr 1999 16:30:08 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id QAA32349; Thu, 22 Apr 1999 16:30:01 -0400 Received: by localhost with Microsoft MAPI; Thu, 22 Apr 1999 16:32:25 -0400 Message-ID: <01BE8CDD.B416B280.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-admin@hub.org'" , "'pgsql-sql@hub.org'" Subject: backend closing channel unexpectedly Date: Thu, 22 Apr 1999 16:32:23 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit --BTW, the update below, when done in psql and with [. . .and ssms.autoinv = 101999;] added (in other words, do it for just one record), it works fine. When I try to do it for multiple records, bombola! Maybe this is for the sql group. . . You know, I have asked this week how to correct some error messages I get when I vacuum related to TUPLE<>HEAP sizes - I thought I caused the problem by setting all relname to lower(relname) in pg_class and attname to lower(attname) in pg_attribute. But I don't think that caused the problem. I was executing an update query today, and got the message "backend closing channel unexpectedly". It bombs no matter how I try to run the query (either from psql [update ssms set technotes = ssmsnotes.technotes from ssmsnotes where ssms.autoinv = ssmsnotes.autoinv;] or from within access97 [UPDATE ssms INNER JOIN ssmsnotes ON ssms.autoinv = ssmsnotes.autoinv SET ssms.technotes = ssmsnotes.technotes;]. I have tried several ways to run the query, but I'm pretty confident in the access97 version - I have used it many times before on this same database (and even the same table) to pull over other fields. Any idea why the old bomb happens? Anywhere for me to check? Do we just attribute it to the overall decline of morals in our (usa) society?? Thanks for help in advance! jt