Re: problem/bug in drop tablespace? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: problem/bug in drop tablespace?
Date
Msg-id CA+TgmoZdnku3rqRqKfeVVCooKHJ19ev1rxJ6X4_xkX8Gi+TZHg@mail.gmail.com
Whole thread Raw
In response to Re: problem/bug in drop tablespace?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: problem/bug in drop tablespace?
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Ensure age() returns a stable value rather than the latest value
Next
From: Robert Haas
Date:
Subject: Re: Draft release notes complete