| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew - Supernews | 2007-07-21 01:02:20 | Re: Solved? Re: 8.2.4 signal 11 with large transaction |
| Previous Message | Andrew Dunstan | 2007-07-20 20:33:58 | Re: Memory leak in vac_update_relstats ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-07-21 09:54:17 | Re: CREATE TABLE LIKE INCLUDING INDEXES support |
| Previous Message | Magnus Hagander | 2007-07-20 20:35:59 | Re: SSPI authentication - patch |