On Mon, 2011-12-12 at 15:40 -0500, Rick Dicaire wrote: > On Mon, Dec 12, 2011 at 3:21 PM, Guillaume Lelarge > <guilla...@lelarge.info> wrote: > > On Mon, 2011-12-12 at 14:01 -0500, Rick Dicaire wrote: > >> Hi folks, I'm generating a dependents report on a db user, I highlight > >> > >> I'm trying to see what sql statement is used to generate this report. > >> > > > > It's something like the SQL in the file I attached. I hope I didn't > > change by mistake while cleaning it. If it doesn't work, take a look at > > the file pgadmin/schema/pgObject.cpp (two functions ShowDependents, and > > ShowDependencies). > > Thanks, got a syntax error in your code...
Did you add the role OID after "WHERE dep.refobjid="? if you didn't, yeah, you'll get a syntax error. > just to be clear, does the > dependents report on a login role show all objects owned by that login > role? > Yes, but you'll get other stuff too. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
