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




Reply via email to