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 <e99re41(at)DoCS(dot)UU(dot)SE>
To: Thomas Swan <tswan(at)olemiss(dot)edu>
Cc: 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 08:10:04
Message-ID: Pine.GSO.4.02A.10005091009001.9107-100000@Uggla.DoCS.UU.SE (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, 9 May 2000, Thomas Swan wrote:

> When using pgaccess to create a new user the followin error results.
> 
> Error executing query
> CREATE user "whomever" WITH PASSWORD "foo" CREATEDB CREATEUSER 
> 
> PostgreSQL error message:
> ERROR: parser: parse error at or near """

The password must be single-quoted nowadays. Put that on the 7.0.1 list
...


-- 
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: Tom LaneDate: 2000-05-09 14:01:00
Subject: Re: Error in pgaccess (parse error at or near """) on create new user with password
Previous:From: Thomas SwanDate: 2000-05-09 07:52:22
Subject: Error in pgaccess (parse error at or near """) on create new user with password

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