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

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

From: Thomas Swan <tswan(at)olemiss(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Error in pgaccess (parse error at or near """) on create new user with password
Date: 2000-05-09 07:52:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
                         POSTGRESQL BUG REPORT TEMPLATE

Your name               :Thomas Swan
Your email address      :tswan(at)ics(dot)olemiss(dot)edu

System Configuration
   Architecture (example: Intel Pentium)         :Intel Celeron

   Operating System (example: Linux 2.0.26 ELF)  : Linux 2.2.15 ELF

   PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-7.0 Release

   Compiler used (example:  gcc 2.8.0)           : egcs-2.91.66

Please enter a FULL description of your problem:
When using pgaccess to create a new user the followin error results.

Error executing query

PostgreSQL error message:
ERROR: parser: parse error at or near """


{any variation of rights reproduces the error}

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:

Try to create  a new user with a password 

If you know how this problem might be fixed, list the solution below:

The with password doesn't like the double quote characters however, writing the same query by hand and using single quotes works...  just change the query or check and make sure the parser will expect double quotes if that is what's expected.  So either it's pgaccess using the wrong SQL statement to create a user or the statement is being incorrectly handled.

- Thomas Swan 
- ________________________________________
- Graduate Student  - Computer Science
- The University of Mississippi
- "People can be sorted into two fundamental groups,
- those that divide people into two groups and 
- those that don't."


pgsql-bugs by date

Next:From: Peter EisentrautDate: 2000-05-09 08:10:04
Subject: Re: Error in pgaccess (parse error at or near """) on create new user with password
Previous:From: Peter EisentrautDate: 2000-05-05 09:41:19
Subject: Re: query slowness caused by table alias

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