Re: [HACKERS] Copy storage parameters on CREATE TABLE LIKE/INHERITS

2008-07-31 Thread ITAGAKI Takahiro
Tom Lane <[EMAIL PROTECTED]> wrote: > There are a couple of other things that need to be thought about: > * LIKE is intended to copy a table as a *portion* of another table; You're absolutely right. I just thought it's a *better default* behavior because LIKE and INHERITS are often used in singl

Re: [HACKERS] Copy storage parameters on CREATE TABLE LIKE/INHERITS

2008-07-30 Thread Tom Lane
daveg <[EMAIL PROTECTED]> writes: > On Wed, Jul 30, 2008 at 04:45:47PM +0900, ITAGAKI Takahiro wrote: >> Here is a patch to copy column storage parameters and reloptions on >> CREATE TABLE LIKE, which I proposed at: > I'd like to have the ability to copy these parameters, but not to have it > be a

Re: [HACKERS] Copy storage parameters on CREATE TABLE LIKE/INHERITS

2008-07-30 Thread daveg
On Wed, Jul 30, 2008 at 04:45:47PM +0900, ITAGAKI Takahiro wrote: > Here is a patch to copy column storage parameters and reloptions on > CREATE TABLE LIKE, which I proposed at: > [HACKERS] Uncopied parameters on CREATE TABLE LIKE > http://archives.postgresql.org/message-id/[EMAIL PROTECTED] >

[HACKERS] Copy storage parameters on CREATE TABLE LIKE/INHERITS

2008-07-30 Thread ITAGAKI Takahiro
Here is a patch to copy column storage parameters and reloptions on CREATE TABLE LIKE, which I proposed at: [HACKERS] Uncopied parameters on CREATE TABLE LIKE http://archives.postgresql.org/message-id/[EMAIL PROTECTED] Column storage parameters (by ALTER COLUMN SET STORAGE) and table storage p