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

  <br /><blockquote cite="mid:CAKFQuwb9MYyyQxOFp5QDc1wjQjsZOPJ964KujvRkTFB1VPgM=g@mail.gmail.com" type="cite"><div
dir="ltr"><divclass="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0
  .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#FFFFFF" text="#000000"><span class=""><blockquote
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><divstyle="font-family:arial,helvetica,sans-serif;display:inline">​ It doesn't make sense to "remove" a
tablespace...thebest you can do is change a table's (and its related indexes) tablespace</div><div
style="font-family:arial,helvetica,sans-serif;display:inline">​</div>  <div
style="font-family:arial,helvetica,sans-serif;display:inline">​from one to another.</div></div><div><div
style="font-family:arial,helvetica,sans-serif;display:inline"><br/></div></div><div><div
style="font-family:arial,helvetica,sans-serif;display:inline">If"ALTER TABLE ... SET TABLESPACE ..." doesn't accomplish
yourgoal you will need to explain yourself better.</div></div></div></div></div></blockquote><br /></span> Want to SET
tablespace= '' for primary key but not table. Tried alter index ... set tablespace='', but empty does not work? <br
/><br/></div></blockquote><div><br /></div><div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">​So, what you want to do is place the primary key index
backonto the default tablespace while the table resides on a different tablespace?</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">Does this work?</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">ALTER INDEX ... SET TABLESPACE
pg_default;</div></div></div></div></div></blockquote>I think this is what I prefer to run. But it seems that schema
ownerdoes not have permission to run it. <br /><br /> "permission denied for tablespace pg_default"<br /><br />
Probablyonly postmaster can run it?<br /><br /> Thanks a lot!<br />