From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)postgresql(dot)org> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Recognize functional dependency on primary keys. |
Date: | 2010-08-14 02:25:45 |
Message-ID: | 201008140225.o7E2PkC08202@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Tom Lane wrote:
> Log Message:
> -----------
> Recognize functional dependency on primary keys. This allows a table's
> other columns to be referenced without listing them in GROUP BY, so long as
> the primary key column(s) are listed in GROUP BY.
>
> Eventually we should also allow functional dependency on a UNIQUE constraint
> when the columns are marked NOT NULL, but that has to wait until NOT NULL
> constraints are represented in pg_constraint, because we need to have
> pg_constraint OIDs for all the conditions needed to ensure functional
> dependency.
>
> Peter Eisentraut, reviewed by Alex Hunsaker and Tom Lane
Because of this commit, I am removing this "we do not want" TODO item:
{{TodoItem
|Indeterminate behavior for the GROUP BY clause (not wanted)
|At least one other database product allows specification of a subset of
the result columns which GROUP BY would need to be able to provide
predictable results; the server is free to return any value from the
group. This is not viewed as a desirable feature.
* [http://archives.postgresql.org/pgsql-hackers/2010-03/msg00297.php
<nowiki>Re: SQL compatibility reminder: MySQL vs PostgreSQL</nowiki>]
}}
My guess is our new 9.1 functionality will reduce requests for this
features, so we can just not list it anymore. If they still ask, we can
re-added this not-wanted item.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2010-08-14 02:28:04 | Re: Re: [COMMITTERS] pgsql: Recognize functional dependency on primary keys. |
Previous Message | Robert Haas | 2010-08-14 02:22:11 | pgsql: Further dtrace adjustments for the backend-IDs-in-relpath patch. |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2010-08-14 02:28:04 | Re: Re: [COMMITTERS] pgsql: Recognize functional dependency on primary keys. |
Previous Message | Robert Haas | 2010-08-14 02:19:58 | Re: Re: [COMMITTERS] pgsql: Include the backend ID in the relpath of temporary relations. |