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

Re: create tablespace fails silently, or succeeds improperly

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create tablespace fails silently, or succeeds improperly
Date: 2010-10-18 18:26:32
Message-ID: 201010181826.o9IIQWJ02299@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane 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?

Well, the symbolic link from data/pg_tblspc points to the top directory,
not to the catalog-version-named subdirectory.  This was done for
several reasons, particularly so the directory pointed to by the symlink
would be exactly the same as that specified by CREATE TABLESPACE, for
code clarity.

Tom, is there a particular permission change you were wondering about?

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

In response to

Responses

pgsql-hackers by date

Next:From: Jeff DavisDate: 2010-10-18 18:29:14
Subject: Re: Floating-point timestamps versus Range Types
Previous:From: Kevin GrittnerDate: 2010-10-18 18:26:07
Subject: Re: Serializable snapshot isolation patch

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