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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
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-09 14:01:00
Message-ID: 11627.957880860@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> writes:
> On Tue, 9 May 2000, Thomas Swan wrote:
>> CREATE user "whomever" WITH PASSWORD "foo" CREATEDB CREATEUSER
>>
>> ERROR: parser: parse error at or near """

> 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>

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Kirkwood 2000-05-10 07:42:12 Cluster fails
Previous Message Peter Eisentraut 2000-05-09 08:10:04 Re: Error in pgaccess (parse error at or near """) on create new user with password