============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your
name
:Thomas Swan
Your email address
:[EMAIL PROTECTED]
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
CREATE user "whomever" WITH PASSWORD "foo"
CREATEDB CREATEUSER
PostgreSQL error message:
ERROR: parser: parse error at or near """
PostgreSQL status: PGRES_FATAL_ERROR
{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."
