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