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

From Tom Lane
Subject Re: Sequence Access Method WIP
Date
Msg-id 94895.1454083396@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sequence Access Method WIP  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
>> On 29 January 2016 at 14:48, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Uh, what?  Surely we would provide a bespoke command for each possible
> sort of handler.  As an example, CREATE INDEX ACCESS METHOD ought to check
> that the provided function has the right signature, and then it would put
> the correct amkind into the pg_am entry automatically.

> I'm thinking we'd do CREATE ACCESS METHOD foobar TYPE INDEX or something
> like that.

That seems okay.  I had the impression you were proposingCREATE ACCESS METHOD foobar TYPE 'i' USING functionname
or something like that, where it would be totally up to the user that
the amkind matched the function.  That seems unnecessarily error-prone,
not to mention that it would close the door forever on any hope that
we might allow non-superusers to execute such commands.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: [WIP] Effective storage of duplicates in B-tree index.
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Template for commit messages