Re: PostgreSQL 9.6: view based on sequence

2018-01-24 14:52 GMT+01:00 Enrico Pirozzi <e.pirozzi@nbsgroup.it>:
> 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@nbsgroup.it
>

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