Postgres Pro
Downloads
Home   >   mailing lists

Re: Error in pgaccess (parse error at or near """) on create new user with password - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Error in pgaccess (parse error at or near """) on create new user with password
Date
Msg-id Pine.LNX.4.21.0005102318221.30279-100000@localhost.localdomain
Whole thread Raw
In response to Re: Error in pgaccess (parse error at or near """) on create new user with password  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Error in pgaccess (parse error at or near """) on create new user with password  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Cluster fails
Next
From: Bruce Momjian
Date:
Subject: Re: Error in pgaccess (parse error at or near """) on create new user with password