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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
