agora inbox for postgres@postgres.berkeley.edu  
help / color / mirror / Atom feed
From: Leland Ellis <leland@straylight.tamu.edu>
To: postgres@postgres.Berkeley.EDU
Cc: leland@straylight.tamu.edu
Subject: [frank@odf.UCSD.EDU: Re: destroyuser]
Date: Mon, 9 May 1994 11:47:16 +0600
Message-ID: <9405091647.AA09488@straylight.tamu.edu> (raw)


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.
===============================================================================




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: postgres@postgres.berkeley.edu
  Cc: leland@straylight.tamu.edu
  Subject: Re: [frank@odf.UCSD.EDU: Re: destroyuser]
  In-Reply-To: <9405091647.AA09488@straylight.tamu.edu>

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

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