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

Wed, 28 Jul 2004 14:17:35 +1000 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Create database and tablespaces