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

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 (view raw or flat)
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  



pgsql-hackers by date

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

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