Re: Issue with GRANT/COMMENT ON FUNCTION with default

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jim Nasby <jim(at)nasby(dot)net>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Issue with GRANT/COMMENT ON FUNCTION with default
Date: 2014-05-06 18:57:43
Message-ID: 536930A7.7040700@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-05-06 19:03:19 btree_gist valgrind warnings about uninitialized memory
Previous Message Stephen Frost 2014-05-06 18:51:18 Re: pgaudit - an auditing extension for PostgreSQL