Christopher Kings-Lynne wrote:
> > Yeah, those are all bug fixes and okay for post-beta I think. But which
> > two tablespace failures are you thinking of exactly? The last couple
> > weeks have been a bit of a blur for me...
>
> 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
I am confused. You had:
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.
but with CVS head I see:
$ psql -a test </tmp/x
create tablespace blah location '/bjm/tmp';
CREATE TABLESPACE
create table foo (i int) tablespace blah;
CREATE TABLE
create database foo tablespace blah;
CREATE DATABASE
However, I don't see any CVS commit that fixed this? What am I missing?
--
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 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html