Re: CREATE TABLESPACE dynamically

Richard Huxton wrote:
> William Garrison wrote:
>> I am writing scripts to create a database that I want to run in my
>> development, testing, and production environments.  That means I need
>> to be able to do something like
>>
>> IF <condition>
>>   CREATE TABLESPACE foo LOCATION E'C:\database';
>> ELSE
>>   CREATE TABLESPACE foo LOCATION E'Z:\database';
>>
>> I can't seem to find a way to do this, for two reasons:
>> 1) I can't do IF statements unless I create a PL/PGSQL function.  And
>> a PL/PGSQL function cannot issue a CREATE TABLESPACE command.

Windows (at least XP & 2003 Server) actually supports real symbolic
links, even if they are not exposed through the UI provided by explorer.
They are called "junktions" on windows, and you can only create linsk to
directories, not to files. But you could use them to e.g. create a link
from C:\postgres.data to E:\postgres.data on one machine, and to
F:\postgres.data on another. Than you can just write "LOCATION
C:\postgres.data" in your script, and it will still use the correct
partition.

This is not an answer to your question, but maybe it's an easier
solution to your problem.

greetings, Florian Pflug