Re: CREATE IF NOT EXISTS INDEX

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: CREATE IF NOT EXISTS INDEX
Дата
Msg-id CAFcNs+qGoT0uRCL-f6-M=OQowQ=u8se4X=M1Dam-gHk4E0cwDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CREATE IF NOT EXISTS INDEX  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Ответы Re: CREATE IF NOT EXISTS INDEX
Список pgsql-hackers


On Fri, Oct 3, 2014 at 12:29 AM, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote:
>
>
>
> On Thu, Oct 2, 2014 at 9:55 PM, Marti Raudsepp <marti@juffo.org> wrote:
> >
> > On Fri, Oct 3, 2014 at 2:15 AM, Marti Raudsepp <marti@juffo.org> wrote:
> > > + ereport(NOTICE,
> > > +                 (errcode(ERRCODE_DUPLICATE_TABLE),
> > > +                  errmsg("relation \"%s\" already exists, skipping",
> > > +                                 indexRelationName)));
> > >
> > > 1. Clearly "relation" should be "index".
> > > 2. Use ERRCODE_DUPLICATE_OBJECT not TABLE
> >
> > My bad, this code is OK. The current code already uses "relation" and
> > TABLE elsewhere because indexes share the same namespace with tables.
> >
>
> Ok. I reply it in other message.
>
>
> > + /*
> > +  * Throw an exception when IF NOT EXISTS is used without a named
> > +  * index
> > +  */
> >
> > I'd say "without an index name". And the line goes beyond 80 characters wide.
> >
>
> Fixed and send in other reply...
>
>
> > I would also move this check to after all the attributes have been
> > assigned, rather than splitting the assignments in half.
> >
>
> Why? If you see other places in gram.y it's a common usage...
>

And just to remember please add your review to commitfest [1] and change the "patch status" to "Waiting on Author" when the author needs to fix/change something.

Thanks for your review!

Regards,

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: CREATE IF NOT EXISTS INDEX
Следующее
От: David G Johnston
Дата:
Сообщение: Re: proposal: doc: simplify examples of dynamic SQL