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
|
| Список | 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 по дате отправления: