I like your text much better --- added. I will throw this email in the 7.5 queue and we can decide if it is a bug then.
If is a bug is better have a patch for the 7.4 May be is only a missing feature. For sure for us was and is actually a nightmare imagine :
V1 -> V2 -> F
/
V3 -> V4
This mean that if a group A can use the view V1 and a group B can use a view V3 whe shall back trace that the function F must be executable by group A due V1 and by group B due V3. Fortunatelly Postgres now take trace of dependencies so we can ( not easily ) analyze each function and see if is used inside a view or not, and choose the right permission.
We have ~ 100 View and ~ 100 functions :-(
Regards Gaetano Mendola
PS: I vote that is a bug :-)
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
