Return-Path: owner-postman 
Delivery-Date: Mon, 09 May 94 12:54:40 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id JAA28311 for postgres-redist; Mon, 9 May 1994 09:51:53 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405091651.JAA28311@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from mail.tamu.edu (TAMU.EDU [128.194.15.22]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id JAA28301 for <postgres@postgres.berkeley.edu>; Mon, 9 May 1994 09:51:52 -0700
Received: from STRAYLIGHT.TAMU.EDU by mail.tamu.edu with SMTP id AA15086
  (5.67b/IDA-1.5 for <postgres@postgres.berkeley.edu>); Mon, 9 May 1994 11:51:47 -0500
Received: by straylight.tamu.edu (5.0/SMI-SVR4)
	id AA09488; Mon, 9 May 1994 11:47:16 +0600
Date: Mon, 9 May 1994 11:47:16 +0600
From: leland@straylight.tamu.edu (Leland Ellis)
Message-Id: <9405091647.AA09488@straylight.tamu.edu>
To: postgres@postgres.Berkeley.EDU
Cc: leland@straylight.tamu.edu
Subject: [frank@odf.UCSD.EDU: Re: destroyuser]
Content-Length: 1534
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 09 May 94 09:51:52 -0700
Resent-XMts: smtp


This fixed the problem w/ destroyuser (Sun SS10, SunOs 4.1.3, Postgres 4.2).

Cheers,

Leland

Return-Path: <frank@odf.UCSD.EDU>
Date: Mon, 9 May 1994 09:20:12 +0800
From: frank@odf.UCSD.EDU (Frank Delahoyde)
To: leland@straylight.tamu.edu
Subject: Re: destroyuser
X-Sun-Charset: US-ASCII
Content-Type: text
Content-Length: 843

This is a bug (at least for Sun sh). A simple fix is included (from the
top of your Postgres distribution, patch -p0 <thisPatch, then from your
src directory, bmake all install).

    _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
   _/    Frank M. Delahoyde    _/ Phone: 619.534.1901        _/
  _/   SIO STS/ODF M/C 0214   _/ Fax: 619.534.7383          _/
 _/ La Jolla, Ca. 92093-0214 _/ Email: frank@odf.ucsd.edu  _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

*** src/bin/destroyuser/destroyuser.sh.orig	Mon May  9 09:03:38 1994
--- src/bin/destroyuser/destroyuser.sh	Mon May  9 09:04:40 1994
***************
*** 85,90 ****
--- 85,91 ----
  QUERY='retrieve (pg_user.usesysid) where pg_user.usename = '"\"$DELUSER\""
  
  RES=`$MONITOR -c "$QUERY" template1`
+ RES=`echo -n $RES`
  
  if [ $? -ne 0 ]
  then

-------------------------------------------------------------------------------

Leland Ellis, Ph.D.
Professor of Biochemistry and Biophysics
Director, W.M. Keck Center for Genome Informatics
Institute of Biosciences and Technology
Texas A&M University
2121 Holcombe
Houston, Texas  77030
email: leland@straylight.tamu.edu
URL:   http://keck.tamu.edu/ibt.html

===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================