Received: from draaw.net (qmailr@puma.draaw.net [199.234.237.21]) by hub.org (8.9.2/8.9.1) with SMTP id MAA46431 for ; Sat, 30 Jan 1999 12:00:56 -0500 (EST) (envelope-from bbrandt@draaw.net) Received: (qmail 13133 invoked by uid 501); 30 Jan 1999 17:00:54 -0000 Message-ID: <19990130120054.45976@draaw.net> Date: Sat, 30 Jan 1999 12:00:54 -0500 From: Bill Brandt To: pgsql-sql@hub.org Subject: Error msg Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88e I'm running 6.3 right now... I've been having a problem that results in this message: PQexec() -- Request was sent to backend, but backend closed the channel before responding. This probably means the backend terminated abnormally before or while processing the request. It occurs anytime someone who does not have the proper permissions attempts to create something in the database. This particular one was caused by the root user attempting to create an index. The problem with it is, that the name of the index is now assigned to something that doesn't exist. I later logged in as postgres (the users postgres is running under) and attempted to execute the same command. I get the following error: ERROR: cannot open cntrsindx If I change the name of the index slightly, it works. I don't know if this is a problem in 6.3 that is fixed in 6.4 or what. I was just wondering if I'm missing something that will free up those entries that "half exist". -- Bill Brandt brandtwr@draaw.net http://www.draaw.net/