Possible Create User Problem

Поиск
Список
Период
Сортировка
От Colin Taylor
Тема Possible Create User Problem
Дата
Msg-id 4BDEC5E174E9D411B5BD00AA00AD07B003A4F4@SERVER3
обсуждение исходный текст
Список 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@portasystems.co.uk

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

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Marek PUBLICEWICZ
Дата:
Сообщение: pg_dump problem
Следующее
От: "Mayers, Philip J"
Дата:
Сообщение: RE: Migrating from MS SQL 7