Re: Uncopied parameters on CREATE TABLE LIKE
От | Simon Riggs |
---|---|
Тема | Re: Uncopied parameters on CREATE TABLE LIKE |
Дата | |
Msg-id | 1216902796.3894.817.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Uncopied parameters on CREATE TABLE LIKE (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>) |
Ответы |
Re: Uncopied parameters on CREATE TABLE LIKE
|
Список | pgsql-hackers |
On Thu, 2008-07-24 at 19:09 +0900, ITAGAKI Takahiro wrote: > CREATE TABLE LIKE is useful to create a new partition from a template > table. We can use 3 options (INCLUDING DEFAULTS, CONSTRAINTS and INDEXES) > to copy more parameters from the template, but there are still some > uncopied parameters: > > 1. column storage parameters (toast options) > 2. reloptions on table (on index is copied already) Sounds good > 3. comments Not sure about that. If comments are just user text, then probably not. I'm guessing you might want that for something else? I would prefer it if you had a plan to introduce user definable parameters, similar to custom_variable_classes. Perhaps call this "custom_table_options". So when we load a table and it has an option we don't recognise we ignore it if it is one of the customer_table_options. custom_table_options will help us define special behaviours for datatypes, indexes, replication etc that relate to the specific role and purpose of individual tables. -- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: