Skip site navigation (1) Skip section navigation (2)

Re: create tablespace fails silently, or succeeds improperly

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: create tablespace fails silently, or succeeds improperly
Date: 2010-10-18 17:24:58
Message-ID: AANLkTi=ZezYmgvuo+bQaUxgGbsYp64asfWEs2dewG5A9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Oct 18, 2010 at 11:37 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>> as seen below create tablespace does not throw an error or appear to
>> do anything other than register the tablespace.
>
> I suspect this behavior is partially intentional, because tablespace
> creation now involves an extra level of subdirectory.  However, it's
> not clear to me why CREATE TABLESPACE is still changing the permissions
> on the parent directory.  Bruce, exactly what is the rationale here?

OK, it appears there are a few loose ends here then as the
documentation http://www.postgresql.org/docs/9.0/interactive/sql-createtablespace.html
says the directory needs to be empty.

Dave

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-10-18 17:28:14
Subject: Re: WIP: extensible enums
Previous:From: Andrew DunstanDate: 2010-10-18 17:15:16
Subject: Re: WIP: extensible enums

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group