GROUP BY can only infer functional dependency from non-deferrable primary keys.
Tom Lane <tgl@sss.pgh.pa.us>
GROUP BY can only infer functional dependency from non-deferrable primary keys. Peter's original patch had this right, but I dropped the check while revising the code to search pg_constraint instead of pg_index. Spotted by Dean Rasheed.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/pg_constraint.c | modified | +4 −1 |