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

create tablespace fails silently, or succeeds improperly

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: create tablespace fails silently, or succeeds improperly
Date: 2010-10-18 15:23:40
Message-ID: AANLkTi=sFem2jDQ4WwqVjy-iygujmC_XPH7bhXHkeP33@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
as seen below create tablespace does not throw an error or appear to
do anything other than register the tablespace.

postgres(at)db01:~> less /opt/pg/data/jnj_indexes/PG_VERSION
8.4
postgres(at)db01:~> /opt/pg91/bin/psql -p 5433
psql (9.0.1)
Type "help" for help.

postgres=# select version();
                                                      version
-------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 3.4.6 20060404 (Red Hat 3.4.6-11), 64-bit
(1 row)

postgres=# create TABLESPACE jnj_indexes location '/opt/pg/data/jnj_indexes';
CREATE TABLESPACE

Dave

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2010-10-18 15:31:12
Subject: Re: create tablespace fails silently, or succeeds improperly
Previous:From: Tom LaneDate: 2010-10-18 15:17:49
Subject: Re: ISN patch that applies cleanly with git apply

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