Re: Functional dependencies and GROUP BY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Functional dependencies and GROUP BY
Дата
Msg-id 18819.1283700945@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Functional dependencies and GROUP BY  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Ответы Re: Functional dependencies and GROUP BY  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> On 5 September 2010 16:15, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I don't recall having thought about it one way or the other. �What did
>> the check look like?

> Well originally it was searching indexes rather than constraints, and
> funcdeps_check_pk() included the following check:

> if (!indexStruct->indisprimary || !indexStruct->indimmediate)
>     continue;

> Now its looping over pg_constraint entries, so I guess anything wtih
> con->condeferrable == true should be ignored.

Seems reasonable, will fix.  Thanks for the report!
        regards, tom lane


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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: Functional dependencies and GROUP BY
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Streaming a base backup from master