Re: proposal: schema private functions

2018-08-23 Thread Pavel Stehule
2018-08-23 17:18 GMT+02:00 Nico Williams : > Couldn't this be handled by having a new permission on FUNCTIONs > ("CALL"?) to distinguish EXECUTE? > I don't understand to this questions. Private functions will be functions still - there is not necessity to call these functions differently. > Thi

Re: proposal: schema private functions

2018-08-23 Thread Nico Williams
Couldn't this be handled by having a new permission on FUNCTIONs ("CALL"?) to distinguish EXECUTE? This would have to be made backwards-compatible, possibly by automatically granting CALL ON ALL FUNCTIONS to public at schema create time and/or PG upgrade time, which the schema owner could then REV

Re: proposal: schema private functions

2018-08-22 Thread Pavel Stehule
2018-08-14 14:00 GMT+02:00 Pavel Stehule : > > > 2018-08-14 13:56 GMT+02:00 Pavel Stehule : > >> Hi >> >> I would to introduce new flag for routines - PRIVATE. Routines with this >> flag can be called only from other routines assigned with same schema. >> Because these routines are not available f

proposal: schema private functions

2018-08-14 Thread Pavel Stehule
Hi I would to introduce new flag for routines - PRIVATE. Routines with this flag can be called only from other routines assigned with same schema. Because these routines are not available for top queries, we can hide these functions from some outputs like \df .. Example: CREATE SCHEMA s1; CREATE

Re: proposal: schema private functions

2018-08-14 Thread Pavel Stehule
2018-08-14 13:56 GMT+02:00 Pavel Stehule : > Hi > > I would to introduce new flag for routines - PRIVATE. Routines with this > flag can be called only from other routines assigned with same schema. > Because these routines are not available for top queries, we can hide these > functions from some