Re: Getting rid of pre-assignment of index names in CREATE TABLE LIKE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Getting rid of pre-assignment of index names in CREATE TABLE LIKE
Date: 2012-07-16 16:43:38
Message-ID: 12133.1342457018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Sat, Jul 14, 2012 at 4:02 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I suggested that we could dodge the problem by allowing IndexStmt to
>> carry a comment to be attached to the new index, and thereby avoid
>> needing an explicit COMMENT command. Attached is a patch that fixes it
>> that way.

> I agree with this approach. I think it's pretty much always a bad
> idea for DDL command A to fake up a parse node of the type used by DDL
> command B. It tends to make the code ugly and unmaintainable and
> propagates nasty abstraction violations all over the place.

Hmm, well, if that's the argument for doing this then we really need to
throw away the entire implementation of CREATE TABLE LIKE, because it's
doing that all over the place; I'm only proposing to remove one specific
instance.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-07-16 16:53:02 Re: [PERFORM] DELETE vs TRUNCATE explanation
Previous Message Robert Haas 2012-07-16 16:37:31 Re: Getting rid of pre-assignment of index names in CREATE TABLE LIKE