Le Jeudi 21 Février 2002 23:39, Dave Page a écrit :
> Without these parsers, we will not be able to track dependencies within
> functions or views.
Why do we need parsers?
pgAdmin I had very simple queries to track dependencies (ILIKE
'%function_foo%' clause).
This suffice to build a provides clause is each object. For example, if
"function_foo" is used in "view_bar" and "function_bar":
function_foo->provides="function:function_bar;view:view_bar"
view_bar->requires="function:function_foo";
function_bar->requires="function:function_foo";
If you prefer, provides = child, requires = father.
I agree this is not as powerfull as a recursive dependency table, but this
suffice to offer 99% security to users. The purpose is not to track n-levels
of dependecies but just visualize 1 level for security reasons.
So why not implement it in pgSchema?
Cheers,
Jean-Michel