BUG #6162: initdb : Windows username isn't escaped

From: "Emmanuel Guyot" <emmanuel(dot)guyot(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6162: initdb : Windows username isn't escaped
Date: 2011-08-14 11:25:22
Message-ID: 201108141125.p7EBPMBS044920@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6162
Logged by: Emmanuel Guyot
Email address: emmanuel(dot)guyot(at)gmail(dot)com
PostgreSQL version: 8.2.3
Operating system: Windows 7
Description: initdb : Windows username isn't escaped
Details:

Initdb crashes when I use it with a windows username that has a quote inside
(e.g. : L'élixir)

Here is the error reported :
initialisation des droits sur les objets internes... 2010-05-14 17:01:25.434
FATAL: syntax error at or near "élixir" at character 44
2010-05-14 17:01:25.434 STATEMENT: UPDATE pg_class SET relacl =
E'{"=r/\\"L'élixir\\""}' WHERE relkind IN ('r', 'v', 'S') AND relacl IS
NULL;

If I force the username as an option with the escaped value L\'élixir the
initdb works fine, but I can't start the server. So I can't find a
workaround.

I've watched the newer sources of initdb and I can't see any change for this
bug.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ali Khamis 2011-08-15 04:49:28 BUG #6163: Installation
Previous Message pasman pasmański 2011-08-13 05:59:58 Re: BUG #6160: Sources from git repository not compile.