Re: [GENERAL] CREATE TABLESPACE dynamically

2007-03-15 Thread Florian G. Pflug
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 CREATE TABLESPACE foo LOCATION E'C:\database'; ELSE CREATE TABLESPACE

Re: [GENERAL] CREATE TABLESPACE dynamically

2007-03-14 Thread Richard Huxton
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 CREATE TABLESPACE foo LOCATION E'C:\database'; ELSE CREATE TABLESPACE foo LOCATION E'Z:\datab

[GENERAL] CREATE TABLESPACE dynamically

2007-03-14 Thread William Garrison
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 CREATE TABLESPACE foo LOCATION E'C:\database'; ELSE CREATE TABLESPACE foo LOCATION E'Z:\database'; I can't seem to fi