Horton

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

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thomas Swan <tswan@olemiss.edu>, pgsql-bugs@postgresql.org
Date: 2000-05-10T21:24:34Z
Lists: pgsql-bugs 
Tom Lane writes:

> > The password must be single-quoted nowadays. Put that on the 7.0.1 list
> 
> I'd say single quotes is correct behavior for the password, actually.
> Double quotes are only appropriate in a position where an SQL name is
> wanted.  The underlying syntax is really
> 	CREATE USER <name> WITH PASSWORD <string>

Yes, that's why we made that change. I was more referring to the pgaccess
"list". Sorry.


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