Re: operator exclusion constraints

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: operator exclusion constraints
Дата
Msg-id 1257558384.27737.574.camel@jdavis
обсуждение исходный текст
Ответ на Re: operator exclusion constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: operator exclusion constraints
Список pgsql-hackers
On Fri, 2009-11-06 at 19:05 -0500, Tom Lane wrote:
> > CREATE TABLE foo
> > (
> >   exclusion int,
> >   EXCLUSION (exclusion CHECK WITH =)
> > );
>
> Well, it looks like it should be able to work, because left-paren
> can't immediately follow a column name AFAIR.

I agree; I don't think it's ambiguous. The other possibility is the
optional "USING index_method" clause in between, but USING is already
reserved, so I don't see a problem there either.

> Maybe I'm missing
> something.  What's your grammar patch exactly, and what does
> bison -v finger as being the problem?
>

bison -v doesn't show anything useful beyond saying that there is one
shift/reduce conflict. The gram.output is 10MB, which doesn't help me
much (I'm still trying to make sense of it). I'd offer to send it along,
but I'm sure bison would produce the same thing for you.

Patch attached with EXCLUSION as a col_name_keyword and one shift/reduce
conflict.

Regards,
    Jeff Davis

Вложения

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: plperl and inline functions -- first draft
Следующее
От: Tom Lane
Дата:
Сообщение: Re: operator exclusion constraints