On Fri, May 11, 2012 at 7:55 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> A larger question is whether we should start making pg_shdepend entries
> for table/index usage of non-default tablespaces, so that you couldn't
> DROP a tablespace that the catalogs think still has tables/indexes in
> it.
I'm astonished we don't do that already. Seems inconsistent with
other SQL object types - most obviously, schemas - and a potentially
giant foot-gun.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company