Date: Wed, 20 Jun 2018 11:05:52 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Bruce Momjian <bruce@momjian.us>
Cc: Pantelis Theodosiou <ypercube@gmail.com>, pgsql-docs@postgresql.org
Subject: Re: Changes in serial / sequence introduced in Postgresql 10
Message-ID: <20180620020552.GB20245@paquier.xyz>
References: 
 <CAE3TBxz4BkhcvYwCxtRpQyqu5NVjMAxgun5vhasM5C+kDcuCRA@mail.gmail.com>
 <CAE3TBxzpRJFF1QhKiEy6ryvgpQwituGbUDqSzi00w-WU7FtRfA@mail.gmail.com>
 <20180619184908.GF3637@momjian.us>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="JYK4vJDZwFMowpUq"
Content-Disposition: inline
In-Reply-To: <20180619184908.GF3637@momjian.us>
Precedence: bulk


--JYK4vJDZwFMowpUq
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Tue, Jun 19, 2018 at 02:49:08PM -0400, Bruce Momjian wrote:
> I don't think we realize there was a behavioral change here.  I think we
> were just trying to fix the case where the sequence maximum didn't match
> the serial maximum.  I am not sure if it is worth documenting it at this
> point though.

Yeah, I agree that it is not worth documenting it.  I don't recall
reviewing the full patch related to identity columns, but I surely
looked at patches which fixed post-commit bugs, and the new behavior is
as a whole more consistent as sequences created with serial map to the
real bound values associated with the underlying column type, and
bigserial does the same:
=# create table test (id bigserial primary key) ;
CREATE TABLE
=# select sequencename, max_value from pg_sequences;
 sequencename |      max_value
--------------+---------------------
 test_id_seq  | 9223372036854775807
(1 row)
--
Michael

--JYK4vJDZwFMowpUq
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlsptoAACgkQnvQgOdby
QH24iA//eyuVYWwBVcb5Lum68tH7V+Qbr+jdiTDlgJlXcVGMaI0BtWlzuTkTZ1Wz
e50qmxsRk5T40Ol096xvv0omG9piJziOYeyD4NWLPrVPZnxCPC9mlGlp+vwlEpg3
b2CcpMyE0RMg/NAPVXbmXyzTl/W8TKe0WSxNxjBaqWANZ0zAAD38oK2S5nnFVbZA
SLNLvuzf71U21+z6lDpsI2PgWI6KwraztdkaBIzhgqTZvCwr5laOggJodmXlI80D
P0xgGM4dmGmzXit6qymN7hQYtlCUnn8AiS9ozBe7PgQhZXgzm+nPTlys7kBF5uyO
rwZpnEo1ddpywCexRze4eHxsJEshQYUJUfgADwNP1p2KsIThjZp6Ghm8bBbAv8/g
lBVZlOfe28cTJRB4BiALRnehOgg+kudeAhkrdxxvbGwvK594tAyd8QNSOEI68HyN
xl9ytjnruefv/BBjKiiqUUrdJOLBFAn270gu92nBgLXJQsCxRy/Fk18tSBAmsnOi
HdGZtcpfp6tYoz/TIfvopMx93V5VWxgRsI1IFOwGDCndBxMw5D9YPgX56g5/AWiJ
TZnOaSQJSJ6/evbIn0jj+cyljxk9T34E7r4WwHtEjbzSpeJSOTFIr/b8p4hBAtKm
LJVbtvnJHetK9MdvH6kvYlKJP0iI8rWsvDwRmtvEhIJ3nwPOPpA=
=q/9w
-----END PGP SIGNATURE-----

--JYK4vJDZwFMowpUq--