Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > However, I don't see any CVS commit that fixed this? What am I missing?
>
> The failure case is where the template database has a conflicting
> table. You didn't show us where you created that table, but it
> evidently was not in template1.
OK, reproduced by using template1:create tablespace blah location '/bjm/tmp';CREATE TABLESPACEcreate table foo (i int)
tablespaceblah;CREATE TABLEcreate database foo tablespace blah;ERROR: could not initialize database directoryDETAIL:
Directory"/u/pgsql/data/pg_tblspc/17229/17232" already exists.
Gavin has posted a patch for this so I will put it in the patch queue.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073