Thread: Dependency Tracking

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/ddl-depend.html
Description:

(ddl-depend.html)
> PostgreSQL will be aware that the get_color_note function depends on the
rainbow type: dropping the type would force dropping the function, because
its argument type would no longer be defined.

Maybe you should add that not only the function will be deleted, but also
the 'color' column of the 'my_colors' table?

PG Doc comments form <noreply@postgresql.org> writes:
> Page: https://www.postgresql.org/docs/17/ddl-depend.html
>> PostgreSQL will be aware that the get_color_note function depends on the
>> rainbow type: dropping the type would force dropping the function, because
>> its argument type would no longer be defined.

> Maybe you should add that not only the function will be deleted, but also
> the 'color' column of the 'my_colors' table?

This paragraph is concerned with the dependency behavior of functions,
so I think adding that comment would just be off-topic complexity.

            regards, tom lane