Possible Create User Problem

From: Colin Taylor <Colin_Taylor(at)portasystems(dot)co(dot)uk>
To: "Pgsql Mailing List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Possible Create User Problem
Date: 2001-03-20 16:24:58
Message-ID: 4BDEC5E174E9D411B5BD00AA00AD07B003A4F4@SERVER3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Yesterday I was using "createuser" to re-set-up my database after an
upgrade.
When prompted for the username, I decided that I needed to get some other
info.
So I just pressed "return".
At the next prompts I typed "n".
I then got the prompt "CREATE USER".
Trouble is, I now have a user with a blank name set-up in my database.

Any ideas how I can get rid of this user with a blank name?
Can I just delete from the "pg_shadow" table, using the user ID?
Is this enough?

Thanks in advance,
Colin
PGSQL Version 7.0.2 on Mandrake 7.2.

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager. postmaster(at)portasystems(dot)co(dot)uk

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2001-03-20 16:26:58 Re: pg_description usage pointers?
Previous Message Oliver Elphick 2001-03-20 15:57:39 Re: grant under SQL92