pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Brandt <brandtwr-pgsql@draaw.net>
To: pgsql-sql@hub.org
Subject: Error msg
Date: Sat, 30 Jan 1999 12:00:54 -0500
Message-ID: <19990130120054.45976@draaw.net> (raw)

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/



view thread (3+ messages)  latest in thread

Message-ID: <19990130120054.45976@draaw.net>
Permalink:  ../19990130120054.45976@draaw.net/
Also on:    postgresql.org/message-id/19990130120054.45976@draaw.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: brandtwr-pgsql@draaw.net, pgsql-sql@hub.org
  Subject: Re: Error msg
  In-Reply-To: <19990130120054.45976@draaw.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox