| 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: | Whole Thread | Raw Message | 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
| 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 |