Skip site navigation (1) Skip section navigation (2)

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Swan <tswan(at)olemiss(dot)edu>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Error in pgaccess (parse error at or near """) on create new user with password
Date: 2000-05-10 21:24:34
Message-ID: Pine.LNX.4.21.0005102318221.30279-100000@localhost.localdomain (view raw or flat)
Thread:
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(at)gmx(dot)net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-05-10 21:26:07
Subject: Re: Error in pgaccess (parse error at or near """) on create new user with password
Previous:From: Mark KirkwoodDate: 2000-05-10 07:42:12
Subject: Cluster fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group