I show this as fixed in CVS. ---------------------------------------------------------------------------
Gavin Sherry wrote: > Attached is a patch resolving the issue raised here: > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&lr=&ie=UTF-8&group=comp.databases.postgresql.hackers&scoring=d&selm=Pine.LNX.4.58.0407281411470.17889%40linuxworld.com.au&rnum=4 > > When I was testing this, I noticed the following: > > template1=# create tablespace blah location '/home/gavins/pgsql/blah'; > CREATE TABLESPACE > template1=# create table foo(i int) tablespace blah; > CREATE TABLE > template1=# create database bar tablespace blah; > ERROR: template database "template1" is already using tablespace "blah" > DETAIL: The default tablespace for a database cannot be in use by the > template > database > template1=# drop table foo; > DROP TABLE > template1=# create database bar tablespace blah; > ERROR: template database "template1" is already using tablespace "blah" > DETAIL: The default tablespace for a database cannot be in use by the > template database > > This happens because even though we drop the only entry in the tablespace > we keep the empty database directory around. > > Should be test if the directory is empty and if so, not copy it (perhaps > only if it is in the tablespace which will be the default tablespace of > the new database?) > > Gavin Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
