Обсуждение: Question about dependency functions in the backend

Hi,

I was wondering whether there is a backend function to help finding the
dependencies on a relation.column inside pg_depend. Something like
dependency.c:0255:findAutoDeletableObjects also taking the "refobjsubid"
with the search. This I ask in order to avoid reinventing the wheel :)

Perhaps the "findAutoDeletableObjects" could be used but the function
name is confusing.

Thanks.

Gevik Babakhani wrote:

> I was wondering whether there is a backend function to help finding the
> dependencies on a relation.column inside pg_depend. Something like
> dependency.c:0255:findAutoDeletableObjects also taking the "refobjsubid"
> with the search. This I ask in order to avoid reinventing the wheel :)
> 
> Perhaps the "findAutoDeletableObjects" could be used but the function
> name is confusing.

Huh, you can certainly give the refobjsubid to findAutoDeletableObjects.
Just set it to a non-zero value.  Note that that function only returns
DEPENDENCY_INTERNAL and DEPENDENCY_AUTO objects however.

What do you need it for?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support