It's rumoured that frank_lupo once said:
>
> The problem is the function pg_get_viewdef. If the view is drop and
> transiction is safe (no commit/rollback) the function lock query.
> Is possible not use this function?
> Is possible that the other functions that returns the definitio!
> n of object have the same limit?
Not that I know of. That is the function to use, so I don't expect there's
a different, working version.
Regards, Dave.