Issue with GRANT/COMMENT ON FUNCTION with default
От | Jim Nasby |
---|---|
Тема | Issue with GRANT/COMMENT ON FUNCTION with default |
Дата | |
Msg-id | 5367EFFF.8070703@nasby.net обсуждение исходный текст |
Ответы |
Re: Issue with GRANT/COMMENT ON FUNCTION with default
Re: Issue with GRANT/COMMENT ON FUNCTION with default |
Список | pgsql-hackers |
Prior to default parameters on functions, GRANT and COMMENT accepted full parameter syntax. IE: GRANT EXECUTE ON test(t text) TO public as opposed to regprocedure, which only accepts the data types ( test(text), not test(t text) ). They do not accept DEFAULT though: GRANT EXECUTE ON FUNCTION test(t text DEFAULT '') to public; ERROR: syntax error at or near "DEFAULT" LINE 1: GRANT EXECUTE ON FUNCTION test(t text DEFAULT '') to public; Presumably this is just an oversight? Related to that, is it intentional that the regprocedure cast disallows *any* decoratorsto the function, other than type? If regprocedure at least accepted the full function parameter definition youcould use it to get a definitive reference to a function. -- Jim C. Nasby, Data Architect jim@nasby.net 512.569.9461 (cell) http://jim.nasby.net
В списке pgsql-hackers по дате отправления: