Hello, > Adam Brightwell <adam.brightw...@crunchydatasolutions.com> writes: > > FWIW, I found the following in the archives: > > > http://www.postgresql.org/message-id/15516.1038718...@sss.pgh.pa.us > > > Now this is from 2002 and it appears it wasn't necessary to change at the > > time, but I haven't yet found anything else related (it's a big archive). > > Though, as I understand it, PUBLIC is now non-reserved as of SQL:2011 which > > might make a compelling argument to leave it as is? > > The current spec does list PUBLIC as a non-reserved keyword, but it also > says (5.4 "Names and identifiers" syntax rules) > > 20) No <authorization identifier> shall specify "PUBLIC". > > which, oddly enough, seems to license us to handle "PUBLIC" the way > we are doing. OTOH, it lists CURRENT_USER as a reserved word, suggesting > that they don't think the same type of hack should be used for that. > > I'd be inclined to leave the grammar as such alone (ie CURRENT_USER is > a keyword, PUBLIC isn't). Changing that has more downside than upside, > and we do have justification in the spec for treating the two cases > differently. However, I agree that we should fix the subsequent > processing so that "current_user" is not confused with CURRENT_USER.
Sure, maybe. - PUBLIC should be left as it is, as an supecial identifier which cannot be used even if quoted under some syntax. - CURRENT_USER should be a kayword as it is, but we shouldn't inhibit it from being used as an identifier if quoted. SESSION_USER and USER should be treated in the same way. We don't want to use something other than string (prefixed by zero-byte) as a matter of course:). And resolving the name to roleid instantly in gram.y is not allowed for the reason shown upthread. So it is necessary to add a new member for the struct, say "int special_role;:... Let me have more sane name for it :( - USER and CURRENT_ROLE are not needed for the syntax other than them which already uses them. I will work on this way. Let me know if something is not acceptable. regards, -- Kyotaro Horiguchi NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers