| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Murali Mohan Kasetty <kasetty(at)india(dot)hp(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Administrator issue |
| Date: | 2002-09-25 17:17:47 |
| Message-ID: | 11546.1032974267@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Murali Mohan Kasetty <kasetty(at)india(dot)hp(dot)com> writes:
> \connect template1 Administrator
> CREATE DATABASE "CYCLE4" WITH TEMPLATE = template0 ENCODING = 'UNICODE';
> \connect CYCLE4 Administrator
I'm thinking that the problem is due to psql downcasing "Administrator"
to "administrator" --- note the spelling in the error message. Old
releases were pretty sloppy about quoting user names consistently in
dumps, so you might find that the easiest answer is just to edit the
dump file and change the usernames to be uniformly lower case.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-09-25 17:17:56 | Re: Prepared statement performance... |
| Previous Message | Tom Lane | 2002-09-25 17:12:03 | Re: Getting current transaction id |