Strange User Problem

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Strange User Problem
Date: 2005-01-20 16:10:23
Message-ID: 20050120161023.46805.qmail@web52401.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

i started up pgsql as i usually do... this time,
though, when i tried to start psql, i got the
following error:

FATAL: database "Owner" does not exist
psql: FATAL: database "Owner" does not exist

i used "Owner" to create my database.

to make matters more interesting...

i was able to connect to pgAdminIII using user
"Owner". when i tried to create another user "Owner",
i received the following error:

ERROR: user "Owner" already exists.

it is pretty interesting to see both these errors, one
after the other, in my cygwin bash shell. ;-)

when i go to "Users(1)" in pgAdminIII and click on
Owner, i see the following sql...

-- User: "Owner"

-- DROP USER "Owner";

CREATE USER "Owner"
WITH SYSID 1
ENCRYPTED PASSWORD ''
CREATEDB CREATEUSER;

is the -- DROP USER "Owner"; normal? i never typed in
that sql at ny time.

any ideas how to get psql to recognize "Owner" exists
would be appreciated.

i'm running the latest cygwin (pgsql 7.4.5) on winxp.
this is the 2nd time i've logged into the pgsql since
installing cygwin. there were no problems the first
time.

tia...


__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-01-20 16:18:31 Re: postgresql log file on fc2
Previous Message Kevin B. 2005-01-20 16:00:43 postgresql log file on fc2