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

From Andreas Zeugswetter
Subject AW: [HACKERS] Re: Bug#21681: postgresql: Doesn't allow granting to www-data
Date
Msg-id 01BD72D1.09BA2F50@zeugswettera.user.lan.at
Whole thread Raw
List 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:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: [HACKERS] Re: User names cannot contain `-'
Next
From: Tom Lane
Date:
Subject: Revised proposal for libpq and FE/BE protocol changes