Find dependecies for some object

PostgreSQL can show you directly only these dependencies:

• table – view
• table column – view
• view – view
• view column – view
• …

You cannot check directly dependencies like:

• table (view) -> function
• table (view) column -> function
• function -> function

If you are used to work with Oracle this could be rather unpleasant surprise for you. Because Oracle does all these checks.

But PostgreSQL does not parse whole source code of the stored function. When you create (replace) function PostgreSQL only check basic things like:

• if there is not some “;” missing
• if PL/pgSQL variables used in code exist
• if all blocks (BEGIN-END/ IF-END IF etc.) are closed

PostgreSQL during creation (replace) of function does not check things like:

• if table / view exists
• if column exist
• if you call other functions properly – number of parameters/ types of parameters
• if you assign variables properly according to types

These possible errors you must check during your tests.

This also means that dependencies on function you must find using for example full text search.

…TODO…