AW: [HACKERS] Re: Bug#21681: postgresql: Doesn't allow granting to www-data

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: "'Oliver Elphick'" <olly(at)lfix(dot)co(dot)uk>
Cc: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>, "'questions(at)postgresql(dot)org'" <questions(at)postgresql(dot)org>
Subject: AW: [HACKERS] Re: Bug#21681: postgresql: Doesn't allow granting to www-data
Date: 1998-04-28 16:10:34
Message-ID: 01BD72D1.09BA2F50@zeugswettera.user.lan.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Yes it is; I hadn't tried double-quotes, because single-quotes are used
> for strings - it didn't occur to me! (Incidentally, WHY double-quotes here
> instead of single-quotes? Surely that's against SQL practice?)

No SQL Standard needs eighter no quotes or double quotes, since
the user name is handeled as an identifier (like a table name).
This is to cleanly distinguish between a string and an identifier.
If you use special characters for user names you have to double quote them.

> bray=> grant all on address to "www-data";
> ERROR: aclparse: mode flags must use "arwR"

This seems to be a different problem.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-04-28 16:18:26 copy command
Previous Message Hannu Krosing 1998-04-28 14:51:02 Re: [INTERFACES] Access'97 and ODBC