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.GSO.4.02A.10005091009001.9107-100000@Uggla.DoCS.UU.SE
Whole thread Raw
In response to Error in pgaccess (parse error at or near """) on create new user with password  (Thomas Swan <tswan@olemiss.edu>)
Responses Re: Error in pgaccess (parse error at or near """) on create new user with password
List pgsql-bugs
Tree view 
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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-bugs by date:

Previous
From: Thomas Swan
Date:
Subject: Error in pgaccess (parse error at or near """) on create new user with password
Next
From: Tom Lane
Date:
Subject: Re: Error in pgaccess (parse error at or near """) on create new user with password