Re: Sequence Access Method WIP - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Sequence Access Method WIP
Date
Msg-id 66776.1454106247@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sequence Access Method WIP  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: Sequence Access Method WIP  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Alexander Korotkov <a.korotkov@postgrespro.ru> writes:
> On Fri, Jan 29, 2016 at 6:36 PM, Alvaro Herrera <alvherre@2ndquadrant.com>
> wrote:
>> I'm thinking we'd do CREATE ACCESS METHOD foobar TYPE INDEX or something
>> like that.

> I would prefer "CREATE {INDEX | SEQUENCE | ... } ACCESS METHOD name HANDLER
> handler;", but I don't insist.

I think that Alvaro's idea is less likely to risk future grammar
conflicts.  We've had enough headaches from CREATE [ UNIQUE ] INDEX
[ CONCURRENTLY ] to make me really wary of variables in the statement-name
part of the syntax.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Optimizer questions
Next
From: Robert Haas
Date:
Subject: Re: Using quicksort for every external sort run