Re: Uncopied parameters on CREATE TABLE LIKE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Uncopied parameters on CREATE TABLE LIKE
Date
Msg-id 200808131503.m7DF3J126425@momjian.us
Whole thread Raw
In response to Re: Uncopied parameters on CREATE TABLE LIKE  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Added to TODO:

>       o Add CREATE TABLE LIKE ... INCLUDING COMMENTS

> * Allow table and index WITH options to be specified via hooks, for use
>   with plugins like GiST index methods


---------------------------------------------------------------------------

ITAGAKI Takahiro wrote:
> 
> Simon Riggs <simon@2ndquadrant.com> wrote:
> 
> > On Tue, 2008-08-12 at 13:34 -0400, Bruce Momjian wrote:
> > > Is there a TODO here?
> > 
> > Yes, three:
> 
> > * create plugin API to allow extensible reloptions
> 
> Yes, and some index access methods (gist and gin) should have
> abilities to handle reloptions in user defined functions, too.
> 
> > * allow reloptions to be copied when using INCLUDING DEFAULTS
> > (if I got that right..)
> 
> The part "INCLUDING DEFAULTS" is not correct. Reloptions are attribute
> of table, not of columns. So they should not be copied on LIKE and INHERITS.
> Of course, we'd better to have convenient way to copy reltoptions from
> another table, but concrete syntax was not suggested in the discussion.
> (and I don't have.)
> 
> > * allow new option to copy comments INCLUDING COMMENTS
> 
> Sure.
> 
> 
> Regards,
> ---
> ITAGAKI Takahiro
> NTT Open Source Software Center
> 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Tim Hawes
Date:
Subject: Re: C Extension woes
Next
From: "Kevin Grittner"
Date:
Subject: Re: Replay attack of query cancel