Filter out temporary tables from resolvable descriptors.

Release justification: low risk, high benefit changes

Release note (sql change): Fix a bug where temporary tables may be
included in `BACKUP` commands.