2011/1/3 Tom Lane :
> select refobjid ... where objid matches and deptype = 'i'
> then it'd be easy, but you only get one UNION ALL per recursive query.
Ah, I see! Thanks for explaining. Now I get it.
--
Best regards,
Joel Jacobson
Glue Finance
--
Sent via pgsql-general mailing list (
Joel Jacobson writes:
> 2011/1/2 Tom Lane
>> The thing you're missing is that implicit dependencies are really
>> bidirectional:
> So, basically it's not possible to define a recursive query only making use
> of pg_depend to build an entire dependency tree of all oids?
> It appears to me it's ne
2011/1/2 Tom Lane
> Greg pointed out to start with that that query was unpolished (and,
> in fact, basically untested ...)
>
> I modified the query like this:
> which is at least a little bit clearer to look at than what you had.
>
Thanks a lot for the help!
I managed to partly solve the proble
Joel Jacobson writes:
> I'm trying to find all recursive dependecies for an object, using the query
> in
> http://archives.postgresql.org/pgsql-general/2009-05/msg01192.php
Greg pointed out to start with that that query was unpolished (and,
in fact, basically untested ...)
I modified the query l
Hi,
I'm trying to find all recursive dependecies for an object, using the query
in
http://archives.postgresql.org/pgsql-general/2009-05/msg01192.php
I ran into problem with view dependencies.
In the example below, the view "b" depends on view "a".
How is it possible to interpret the result of t
