Re: CREATE TABLE LIKE INCLUDING INDEXES support

From: NikhilS <nikkhils(at)gmail(dot)com>
To: "Neil Conway" <neilc(at)samurai(dot)com>
Cc: "Bruce Momjian" <bruce(at)momjian(dot)us>, "Trevor Hardcastle" <chizu(at)spicious(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Date: 2007-05-02 11:39:16
Message-ID: d3c4af540705020439l68c99a8fya22b30959fb196d9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi Neil,

>
> * the patch is broken for expressional indexes, and silently omits
> copying the predicate that may be associated with an index. It also
> doesn't copy the index's amoptions (WITH clause), or the NULLS
> FIRST/etc. options that may be associated with any of the index's
> columns.

Since this patch is only supposed to copy unique/primary indexes, I dont
think we will ever have predicates associated to such indexes?

Regards,
Nikhils

--
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-05-02 11:50:14 Re: Patch queue triage
Previous Message Zdenek Kotala 2007-05-02 11:31:31 Re: Heap page diagnostic functions

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2007-05-02 12:51:53 Re: [GENERAL] dropping role w/dependent objects
Previous Message Bruce Momjian 2007-05-02 11:05:39 Re: non-recursive WITH clause support