| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> | 
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> | 
| Cc: | pgsql-hackers(at)postgresql(dot)org, Jacob Champion <pchampion(at)vmware(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Ashwin Agrawal <aagrawal(at)pivotal(dot)io>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com> | 
| Subject: | Re: alter table set TABLE ACCESS METHOD | 
| Date: | 2021-03-08 01:07:07 | 
| Message-ID: | 20210308010707.GA29832@telsasoft.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
On Mon, Mar 01, 2021 at 11:16:36AM +0900, Michael Paquier wrote:
> On Sun, Feb 28, 2021 at 04:25:30PM -0600, Justin Pryzby wrote:
> > I called this "set TABLE access method" rather than just "set access method"
> > for the reasons given on the LIKE thread:
> > https://www.postgresql.org/message-id/20210119210331.GN8560@telsasoft.com
> 
> ALTER TABLE applies to a table (or perhaps a sequence, still..), so
> that sounds a bit weird to me to add again the keyword "TABLE" for
> that.
This renames to use SET ACCESS METHOD (resolving a silly typo);
And handles the tuple slots more directly;
And adds docs and tab completion;
Also, since 8586bf7ed8889f39a59dd99b292014b73be85342:
|    For now it's not allowed to set a table AM for a partitioned table, as
|    we've not resolved how partitions would inherit that. Disallowing
|    allows us to introduce, if we decide that's the way forward, such a
|    behaviour without a compatibility break.
I propose that it should behave like tablespace for partitioned rels:
ca4103025dfe, 33e6c34c3267
-- 
Justin
| Attachment | Content-Type | Size | 
|---|---|---|
| v2-0001-ALTER-TABLE-SET-ACCESS-METHOD.patch | text/x-diff | 17.5 KB | 
| v2-0002-Allow-specifying-acccess-method-of-partitioned-ta.patch | text/x-diff | 11.1 KB | 
| v2-0003-Implement-lsyscache-get_rel_relam.patch | text/x-diff | 2.9 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2021-03-08 01:09:22 | Re: [PATCH] pg_permissions | 
| Previous Message | Thomas Munro | 2021-03-08 01:03:08 | Re: 011_crash_recovery.pl intermittently fails |