2018-01-24 14:52 GMT+01:00 Enrico Pirozzi <e.pirozzi@xxxxxxxxxxx>: > Yes the query is legal,but if you use pg_upgrade to upgrade from 9.6 to 10.x > , pg_upgrade will fail . > > Enrico > > > > Il 24/01/2018 13:11, Vincenzo Romano ha scritto: >> >> Those queries are all legal. No warning is due. > > > -- > Enrico Pirozzi > e.pirozzi@xxxxxxxxxxx > It is all documented here: https://www.postgresql.org/docs/10/static/release-10.html#idm46428658049888 "...selecting from a sequence relation now returns only the three fields named above." And there's no way to keep portability from 9.x to 10.x -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS
