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

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