Re: [HACKERS] More thoughts on drop tablespace

2004-07-06 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > The same thing may also apply to the default tablespace of a database as > well... No, because it will always contain some files (at the very least, the db's pg_class *must* live there). See prior thread about exactly this issue.

Re: [HACKERS] More thoughts on drop tablespace

2004-07-06 Thread Christopher Kings-Lynne
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 emp

Re: [HACKERS] More thoughts on drop tablespace

2004-07-06 Thread Andreas Pflug
Christopher Kings-Lynne wrote: The same thing may also apply to the default tablespace of a database as well... Well at least the database can be queried easily for usage of that tablespace. For the namespace issue, it would help if *some* object would be created with that namespace (e.g. an em

[HACKERS] More thoughts on drop tablespace

2004-07-06 Thread Christopher Kings-Lynne
The same thing may also apply to the default tablespace of a database as well... Chris ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]