Re: pgsql-server: Add ALTER INDEX, particularly for moving - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql-server: Add ALTER INDEX, particularly for moving
Date
Msg-id 200408211846.i7LIks022953@candle.pha.pa.us
Whole thread Raw
In response to Re: pgsql-server: Add ALTER INDEX, particularly for moving tablespaces.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql-server: Add ALTER INDEX, particularly for  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-committers
Tom Lane wrote:
> momjian@svr1.postgresql.org (Bruce Momjian) writes:
> > Add ALTER INDEX, particularly for moving tablespaces.
>
> This patch is a perfect example of why unreviewed patches should not
> go in during beta.
>
> So far I have noticed the following problems with it:
>
> * Added reference page wasn't linked into the docs build.
>
> * Added a field to struct AlterTableStmt, but did not do the necessary
>   housekeeping for extending a Node (eg, copyfuncs and equalfuncs
>   adjustments), nor make sure the field is validly set in every place
>   an AlterTableStmt is constructed.
>
> * ALTER INDEX RENAME doesn't actually work.
>
> regression=# alter index foo_pkey rename to zzz;
> ERROR:  unrecognized rename stmt type: 9
>
> That's not counting the problem someone else already reported with
> incorrect tab-completion.

Yes, you are right.  Because Gavin is "Mr Tablespaces" I didn't give it
a thorough read.

FYI, I just fixed the tab completion problem.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-committers by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql-server: Fix tab completion for ALTER INDEX.
Next
From: "Marc G. Fournier"
Date:
Subject: Re: pgsql-server: Add ALTER INDEX, particularly for