Re: CREATE TABLE LIKE INCLUDING INDEXES support - Mailing list pgsql-patches

From NikhilS
Subject Re: CREATE TABLE LIKE INCLUDING INDEXES support
Date
Msg-id d3c4af540706030702o47fd9745i67f13f78e689d7a8@mail.gmail.com
Whole thread Raw
In response to Re: CREATE TABLE LIKE INCLUDING INDEXES support  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: CREATE TABLE LIKE INCLUDING INDEXES support
List pgsql-patches
Hi,

On 6/3/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Neil Conway <neilc@samurai.com> writes:
> Attached is a revised version of this patch.

This still seems to fundamentally misunderstand the difference between
an index and a constraint.  IMHO it should not be examining pg_index
(or specifically, the index Relations) at all.
 
 
But as you had mentioned earlier, if we look at index entries as part of the implementation of "unique" or "primary key" pg_constraint entries, then examining pg_index is required, right?
 
Anyways, this patch and the functionality introduced herein will be useful in the "CREATE .. INCLUDING INDEXES" case too.
 
Regards,
Nikhils
 
-- 
EnterpriseDB               http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: NikhilS
Date:
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Next
From: Tom Lane
Date:
Subject: Re: GUC temp_tablespaces (updated)