Re: remove tablespace for primary key (*not* by drop/recreate constraint)

Hello,  <br /><blockquote cite="mid:CAKFQuwaCfLjPv1UxfpkQUgN1Fh1AuZS=nHWXWKX5t-=U+9qfBg@mail.gmail.com"
type="cite"><divdir="ltr"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote"
style="margin:0px0px 0px
 
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">to remove
tablespacefor primary key please?<br /><br /> For example, z1 (c1 text) with pk_z1 PRIMARY KEY (c1), tablespace
"abc"<br/><br /> May I know how to remove tablespace(set tablespace to empty for z1)?<br /></blockquote><div><br
/></div><div><divclass="gmail_default" style="font-family:arial,helvetica,sans-serif;display:inline">​ It doesn't make
senseto "remove" a tablespace...the best you can do is change a table's (and its related indexes) tablespace</div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif;display:inline">​</div>   <div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">​from one to another.</div></div><div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif;display:inline"><br /></div></div><div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif;display:inline">If "ALTER TABLE ... SET TABLESPACE
..."doesn't accomplish your goal you will need to explain yourself
better.</div></div></div></div></div></blockquote><br/> Want to SET tablespace = '' for primary key but not table.
Triedalter index ... set tablespace='', but empty does not work? <br /><br /> Thanks<br /><br />