Horton

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

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Thomas Swan <tswan@olemiss.edu>, pgsql-bugs@postgresql.org
Date: 2000-05-10T21:26:07Z
Lists: pgsql-bugs 
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> 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, is this a pgaccess bug?  If so, can you contact the author?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026