Horton

Re: create tablespace fails silently, or succeeds improperly

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephen Frost <sfrost@snowman.net>
Cc: Robert Haas <robertmhaas@gmail.com>, Bruce Momjian <bruce@momjian.us>, Dave Cramer <pg@fastcrypt.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-12-11T15:56:19Z
Lists: pgsql-hackers 
Stephen Frost <sfrost@snowman.net> writes:
> * Robert Haas (robertmhaas@gmail.com) wrote:
>> On Fri, Dec 10, 2010 at 10:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Anybody have a problem with adopting this behavior?

>> Seems a bit surprising.

> Yeahh..  I'm not really sure about mkdir -p type actions from a SQL
> command.  Not entirely sure why but it doesn't feel 'right' to me.  I'd
> rather have PG complain "that directory doesn't exist".

OK.  Is there any value in doing mkdir -p in WAL-recovery execution of
CREATE TABLESPACE but not regular execution?

			regards, tom lane