Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA16458; Thu, 18 Jun 92 14:10:25 -0700
Message-Id: <9206182110.AA16458@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: remove operator fails
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Thu, 18 Jun 92 12:55:01 PDT."
             <9206181955.AA15547@postgres.Berkeley.EDU> 
Date: Thu, 18 Jun 92 14:10:15 PDT

you write:
> 
> I have created an operator,
> 
> define operator = (arg1 = _char, arg2 = _char, commutator = "=", negator = "!
 +=",
> procedure = sequal)
> 
> When I wish to remove this, I get the following:
> 
> * remove operator = (_char,_char) \g
> 
> Query sent to backend is "remove operator = (_char,_char) "
> Error: No response from the backend, exiting...

I can't reproduce this.  Can you look for a core file under
$POSTGRESHOME/data/base/<dbname>  and send a stack trace if it exists?

> Is there a workaround?

yes:

	delete pg_o
	from pg_o in pg_operator, pg_t in pg_type
	where pg_o.oprleft = pg_t.oid and
	      pg_o.oprright = pg_t.oid and
	      pg_o.oprname = "=" and
	      pg_t.name = "_char" 


Jeff Meredith
mer@postgres.berkeley.edu