Re: Functional dependencies and GROUP BY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Functional dependencies and GROUP BY
Date
Msg-id 18819.1283700945@sss.pgh.pa.us
Whole thread Raw
In response to Re: Functional dependencies and GROUP BY  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Functional dependencies and GROUP BY
List 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 by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Functional dependencies and GROUP BY
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Streaming a base backup from master