| From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: remove tablespace for primary key (*not* by drop/recreate constraint) |
| Date: | 2015-06-05 13:33:05 |
| Message-ID: | 5571A511.9020805@encs.concordia.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<br>
<blockquote
cite="mid:CAKFQuwb9MYyyQxOFp5QDc1wjQjsZOPJ964KujvRkTFB1VPgM=g(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">
<div class="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 text="#000000" bgcolor="#FFFFFF"><span class="">
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">to
remove tablespace for 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>
<div
style="font-family:arial,helvetica,sans-serif;display:inline">
It doesn't make sense to "remove" a
tablespace...the best 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 your goal 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
back onto 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 owner
does not have permission to run it. <br>
<br>
"permission denied for tablespace pg_default"<br>
<br>
Probably only postmaster can run it?<br>
<br>
Thanks a lot!<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 4.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2015-06-05 13:47:49 | Re: remove tablespace for primary key (*not* by drop/recreate constraint) |
| Previous Message | David G. Johnston | 2015-06-04 18:51:15 | Re: remove tablespace for primary key (*not* by drop/recreate constraint) |