I can confirm this is fixed in current CVS:
test=> CREATE TABLESPACE tsp LOCATION '/bjm/tmp';
CREATE TABLESPACE
test=> CREATE SCHEMA s TABLESPACE tsp;
CREATE SCHEMA
test=> DROP TABLESPACE tsp;
DROP TABLESPACE
test=> CREATE TABLE s.t
Added to open items list:
* Fix error message when creating objects in schema that has a
dropped tablespace as its default
I can confirm the bug still exists in CVS.
---
Fabien COELHO wrote:
>
> Dear Tom
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> Suggested fix: create some empty file in the directory
> if it is used by a namespace.
This was discussed and rejected before --- the problem is not worth the
amount of mechanism that would have to be added to fix it this way.
See the pghackers
The following bug has been logged online:
Bug reference: 1236
Logged by: Fabien
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 Beta
Operating system: Linux debian
Description:still in use tablespaces can be removed
Details:
Sorry if this bug was alrea
