Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199408041814.LAA02420@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: KUFONIYI@ITC.NL
Date: Thu, 4 Aug 1994 10:10:46 GMT+0200
Subject: destroyuser() problem
To: postgres@postgres.Berkeley.EDU
Message-id: <01HFI9VZ7BPU003SSH@ITC.NL>
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 04 Aug 94 11:14:33 -0700
Resent-XMts: smtp

Hello Postgres Users,

We have just installed postgres version 4.2 on H-P 9000 running HPUX 9.03.
The regression test did not give any strange results. But we got an error 
message when we try to destroy any user. The postmaster was running on the 
same (remote) host as Postgres while the user is on another host. The host 
name (for postgres and postmaster) was stated in the destroyuser command.
Other queries tested so far (e.g., createdb, retrieve, append, destroy, etc.)
worked fine. The destroyuser command also works fine on our old Postgres v4.0.1
(installed on another HP host).  
What are we doing wrong? Any help will be greatly appreciated. 
Below is the list of the commands and queries we excuted.

hp23 24: createuser -h hp31 mahdi  /* hp23 is the user's host and hp31 is 
                                      POSTGRES/POSTMASTER's host */
Enter user's postgres ID or RETURN to use unix user ID: 420 ->
Is user "mahdi" allowed to create databases (y/n) y
Is user "mahdi" allowed to create users (y/n) n
createuser: mahdi was successfully added


hp23 32: monitor -h hp31 test1
Welcome to the POSTGRES terminal monitor

* 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    | 2435        |
-----------------------------
| olajide     | 421         |
-----------------------------
| mahdi       | 420         |
-----------------------------

Go

hp23 25: destroyuser -h hp31 mahdi
WARN:Aug  3 15:29:04:pg_atoi: error in " 420         ": can't parse "         "
destroyuser: database access failed - exiting...

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


Jide Kufoniyi         e-mail: kufoniyi@itc.nl
ITC, Enschede
The Netherlands.


==============================================================================
   To add/remove yourself to/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.
==============================================================================