Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tZAma-002ip0-JH
	for pgsql-admin@arkaria.postgresql.org; Sat, 18 Jan 2025 15:30:45 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tZAmX-000sYR-EG
	for pgsql-admin@arkaria.postgresql.org; Sat, 18 Jan 2025 15:30:41 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1tZAmW-000sYG-VD
	for pgsql-admin@lists.postgresql.org; Sat, 18 Jan 2025 15:30:41 +0000
Received: from mailout.easymail.ca ([64.68.200.34])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1tZAmV-000DVn-0K
	for pgsql-admin@lists.postgresql.org;
	Sat, 18 Jan 2025 15:30:40 +0000
Received: from localhost (localhost [127.0.0.1])
	by mailout.easymail.ca (Postfix) with ESMTP id C78C16162B
	for <pgsql-admin@lists.postgresql.org>; Sat, 18 Jan 2025 15:30:37 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1737214237;
	bh=6lbSYIgD8V4+Tc/5bLBSewwHCV3kEuOdfCgs9NuBsOU=;
	h=From:Subject:Date:To:From;
	b=RgbSFfO6SvCR6aFgJZTbk/Ptq3G1MxF3YyfDYocZpp4XaD3ti2A2hwIJv9r9lZ4hl
	 z9IFKTzO2gKqtsDJMIT4CQ5IDqt+wlsAYu0ar1kwuuNwhxEf1T86GB9RrCA2gfCPf5
	 CZSVVUaXbS92kun3ssZDnI9szzoMdd9MOqxzo8amKXmkcSXWsG/Ai7PheCrlnyA1gD
	 OR0vdGAxOQyFV4e0JxeMXTdc/+5QPPINGDx0Knh8tQQkduFadodTYsZ1I9AJJ48FLs
	 J3G5bk0mns/0YN1QyV+7RFyzs2zs6SQYDg0fxq6GZvUG6oR9FT/Zy7eks47xCXqHzo
	 5DyV7UHv+TJ0g==
X-Virus-Scanned: Debian amavisd-new at emo09-pco.easydns.vpn
Received: from mailout.easymail.ca ([127.0.0.1])
	by localhost (emo09-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id m7PljT34DdDu for <pgsql-admin@lists.postgresql.org>;
	Sat, 18 Jan 2025 15:30:37 +0000 (UTC)
Received: from smtpclient.apple (unknown [165.140.184.195])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by mailout.easymail.ca (Postfix) with ESMTPSA id 6022B61629
	for <pgsql-admin@lists.postgresql.org>; Sat, 18 Jan 2025 15:30:37 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1737214237;
	bh=6lbSYIgD8V4+Tc/5bLBSewwHCV3kEuOdfCgs9NuBsOU=;
	h=From:Subject:Date:To:From;
	b=RgbSFfO6SvCR6aFgJZTbk/Ptq3G1MxF3YyfDYocZpp4XaD3ti2A2hwIJv9r9lZ4hl
	 z9IFKTzO2gKqtsDJMIT4CQ5IDqt+wlsAYu0ar1kwuuNwhxEf1T86GB9RrCA2gfCPf5
	 CZSVVUaXbS92kun3ssZDnI9szzoMdd9MOqxzo8amKXmkcSXWsG/Ai7PheCrlnyA1gD
	 OR0vdGAxOQyFV4e0JxeMXTdc/+5QPPINGDx0Knh8tQQkduFadodTYsZ1I9AJJ48FLs
	 J3G5bk0mns/0YN1QyV+7RFyzs2zs6SQYDg0fxq6GZvUG6oR9FT/Zy7eks47xCXqHzo
	 5DyV7UHv+TJ0g==
From: Scott Ribe <scott_ribe@elevated-dev.com>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.300.87.4.3\))
Subject: release notes 17, identity columns
Message-Id: <9B8068E5-66E0-4C03-A728-8EE10671D764@elevated-dev.com>
Date: Sat, 18 Jan 2025 08:30:27 -0700
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
X-Mailer: Apple Mail (2.3826.300.87.4.3)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/9B8068E5-66E0-4C03-A728-8EE10671D764%40elevated-dev.com>
Precedence: bulk

I notice the release notes don't have a "submit a correction" link...

I think identity column inheritance should have a note in the =
incompatibilities section. If you have an automated partition creation =
process which adds the default to inherited columns where the base table =
specifies identity, that will break.

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/