Re: Issue with GRANT/COMMENT ON FUNCTION with default - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Issue with GRANT/COMMENT ON FUNCTION with default
Date
Msg-id 536930A7.7040700@gmx.net
Whole thread Raw
In response to Issue with GRANT/COMMENT ON FUNCTION with default  (Jim Nasby <jim@nasby.net>)
Responses Re: Issue with GRANT/COMMENT ON FUNCTION with default
List pgsql-hackers
On 5/5/14, 4:09 PM, Jim Nasby wrote:
> 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?

It appears to be specified that way in SQL.  The DEFAULT clause is not
part of the function signature.




pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pgaudit - an auditing extension for PostgreSQL
Next
From: Andres Freund
Date:
Subject: btree_gist valgrind warnings about uninitialized memory