Horton

Re: Error in pgaccess (parse error at or near """) on create new user with password

Peter Eisentraut <e99re41@docs.uu.se>

View thread
From: Peter Eisentraut <e99re41@DoCS.UU.SE>
To: Thomas Swan <tswan@olemiss.edu>
Cc: pgsql-bugs@postgresql.org
Date: 2000-05-09T08:10:04Z
Lists: pgsql-bugs 
On Tue, 9 May 2000, Thomas Swan wrote:

> When using pgaccess to create a new user the followin error results.
> 
> Error executing query
> CREATE user "whomever" WITH PASSWORD "foo" CREATEDB CREATEUSER 
> 
> PostgreSQL error message:
> ERROR: parser: parse error at or near """

The password must be single-quoted nowadays. Put that on the 7.0.1 list
...


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden