Re: More thoughts on drop tablespace

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: More thoughts on drop tablespace
Date: 2004-07-06 10:51:57
Message-ID: 40EA844D.1050107@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Well at least the database can be queried easily for usage of that
> tablespace.

Yes, that's the easy part to fix. You'd just set the dattablespace back
to 0 when you dropped the tablespace.

> For the namespace issue, it would help if *some* object would be created
> with that namespace (e.g. an empty directory or file with the namespace
> oid), so that pg_tablespace_databases() could detect it.

Seems like the only way.

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message spock 2004-07-06 10:54:55 Re: Point in Time Recovery
Previous Message Gavin Sherry 2004-07-06 10:51:50 Re: bug in DROP TABLESPACE