Return-Path: owner-postman Delivery-Date: Mon, 09 May 94 13:36:05 -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 IAA27499 for postgres-redist; Mon, 9 May 1994 08:23:06 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199405091523.IAA27499@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 IAA27489 for ; Mon, 9 May 1994 08:23:05 -0700 Received: from STRAYLIGHT.TAMU.EDU by mail.tamu.edu with SMTP id AA13522 (5.67b/IDA-1.5 for ); Mon, 9 May 1994 10:23:03 -0500 Received: by straylight.tamu.edu (5.0/SMI-SVR4) id AA04428; Mon, 9 May 1994 10:18:37 +0600 Date: Mon, 9 May 1994 10:18:37 +0600 From: leland@straylight.tamu.edu (Leland Ellis) Message-Id: <9405091518.AA04428@straylight.tamu.edu> To: postgres@postgres.Berkeley.EDU Cc: leland@straylight.tamu.edu Subject: destroyuser Content-Length: 1271 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Mon, 09 May 94 08:23:05 -0700 Resent-XMts: smtp Hello, do you know what the origin of this message is? User leland was created with createuser, name leland, uid 100 and y and y. User postgres was created by the system, not by createuser. Thanks in advance, Leland --------------------------------------------------------------------------------- keck% monitor demo Welcome to the POSTGRES terminal monitor Go * retrieve (u.usename,u.usesysid) from u in pg_user\g Query sent to backend is "retrieve (u.usename,u.usesysid) from u in pg_user" ----------------------------- | usename | usesysid | ----------------------------- | postgres | 110 | ----------------------------- | leland | 100 | ----------------------------- Go * \q keck% destroyuser Enter name of user to delete ---> leland WARN:May 9 10:22:20:pg_atoi: error in " 100 ": can't parse " " destroyuser: database access failed - exiting... -------------------------------------------------------------------------------- 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. ===============================================================================