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
> the user as shown in Login Roles, right click -> reports -> Dependents
> Report,
> but I see the "Include the SQL in the report" checkbox greyed out (a
> checkmark shows in it) in the dialog box.
>
> Resultant report doesn't have the sql statement in it. I've tried both
> xhtml and xml output.
>
> 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).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com