Re: RFC: listing lock status

>  > Rather than adding another SHOW command, I think using a table
>  > function is a better idea. That's because the information returned by
>  > the lock listing code will often need to be correlated with other
>  > information in the system catalogs, or sorted/aggregated in various
>  > ways (e.g. "show me the names of all locked relations", or "show me
>  > the relation with the most AccessShareLocks'"). Written as a table
>  > function, the lock listing code itself can be fairly simple, and the
>  > DBA can write the necessary SQL queries to produce the information he
>  > needs. It also makes it easier to parse the lock status information,
>  > if you're writing (for example) a GUI admin tool.

Out of interest - why do SRFs need to have a table or view defined that
matches their return type?  Why can't you just create the type for the
function and set it up as a dependency?

Chris