From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
        Daniel Gustafsson <daniel@yesql.se>,
        "zedaardv@drizzle.com" <zedaardv@drizzle.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17720: pg_dump creates a dump with primary key that cannot
 be restored, when specifying 'using index ...'
In-reply-to: 
 <CAKFQuwZtkWoY_GfPxBp1v6qYiw=D=LdJejcpw8MjyhFzNNj05g@mail.gmail.com>
References: <17720-dab8ee0fa85d316d@postgresql.org>
 <CAKFQuwam=1NoSNH=EJRUnuuD8JE_jM8tq22-SYqO1nxzoXFwzg@mail.gmail.com>
 <9C039DE3-EFBD-4D65-B4CF-90D8148B7B4C@yesql.se>
 <2684951.1671032222@sss.pgh.pa.us>
 <CAKFQuwZtkWoY_GfPxBp1v6qYiw=D=LdJejcpw8MjyhFzNNj05g@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Wed, 14 Dec 2022 08:59:26 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2688006.1671034096.1@sss.pgh.pa.us>
Date: Wed, 14 Dec 2022 11:08:16 -0500
Message-ID: <2688007.1671034096@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2688007.1671034096%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> I am thinking now that the failure to include NULLS [NOT] DISTINCT in the
> CREATE TABLE syntax is an oversight that needs to be fixed.  It just
> doesn't make sense to have the two commands expose different features.

It looks to me like it was pretty intentional, because both CREATE
and ALTER TABLE let you write UNIQUE NULLS NOT DISTINCT but not
PRIMARY KEY NULLS NOT DISTINCT.  That doesn't seem like an oversight.

			regards, tom lane