Skip site navigation (1) Skip section navigation (2)

Re: CREATE TABLE LIKE INCLUDING INDEXES support

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, neilc(at)samurai(dot)com,nikkhils(at)gmail(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us, bruce(at)momjian(dot)us,chizu(at)spicious(dot)com, pgsql-patches(at)postgresql(dot)org
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Date: 2007-07-20 21:01:29
Message-ID: 20070720210129.GE39272@nasby.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Fri, Jul 20, 2007 at 12:40:46PM +0100, Gregory Stark wrote:
> "Tatsuo Ishii" <ishii(at)sraoss(dot)co(dot)jp> writes:
> 
> > Can someone enligten me what the usecase for CREATE TABLE LIKE at this
> > moment is?
> 
> One of the main use cases I envision is wanting to create new partitions
> suitable for being added to a partitioned table.

Except that's normally done with CREATE TABLE INHERITS, which seems
cleaner to me. I think the patch would be more useful if it added
support for INHERITS, but I don't object to it as-is.
-- 
Jim Nasby                                      decibel(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-hackers by date

Next:From: Andrew - SupernewsDate: 2007-07-21 01:02:20
Subject: Re: Solved? Re: 8.2.4 signal 11 with large transaction
Previous:From: Andrew DunstanDate: 2007-07-20 20:33:58
Subject: Re: Memory leak in vac_update_relstats ?

pgsql-patches by date

Next:From: Gregory StarkDate: 2007-07-21 09:54:17
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Previous:From: Magnus HaganderDate: 2007-07-20 20:35:59
Subject: Re: SSPI authentication - patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group