Hi all, We have the following:
template1=# create tablespace blah location '/home/swm/tbl/tspc1/'; CREATE TABLESPACE template1=# create table foo (i int) tablespace blah; CREATE TABLE template1=# create database foo tablespace blah; ERROR: could not initialize database directory DETAIL: Directory "/home/swm/tbl/data/pg_tblspc/17227/17230" already exists. The comment in dbcommands.c makes it clear that we don't want to allow situations where the template database has entries in the target database's default database but the error message is rather unhelpful. I think that this also needs to be documented. The question is, should we check if the template database has a non empty directory under the target database's default database rather than let it come through to this. Gavin ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])