| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | Bill Barnes <bbarnes(at)operamail(dot)com> |
| Cc: | postgres general mail list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Creating new user in vers 7.02 and pgaccess |
| Date: | 2000-05-26 12:51:05 |
| Message-ID: | Pine.GSO.4.02A.10005261449320.12244-100000@Falk.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 26 May 2000, Bill Barnes wrote:
> Connected to template1 as user 'postgres'.
> Creating a new user reported an error in SQL parsing.
> Found that I could create a new user by omitting any password.
> Was able to edit that new user to super user privileges.
> Attempting to add a password again reported the query parsing error.
You need to write CREATE USER name WITH PASSWORD 'password here'. Note the
single quotes, that has changed. pgaccess hasn't caught up with that yet
but it will be okay in the 7.0.1 release.
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2000-05-26 12:55:42 | Re: problem with NOTICE: _outNode: don't know how to print type |
| Previous Message | Shaw Terwilliger | 2000-05-26 12:36:06 | Re: What distribution? |