Re: PostgreSQL 9.6: view based on sequence - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: PostgreSQL 9.6: view based on sequence
Date
Msg-id CAHjZ2x4H7v3KhPFn2v1j4KZDJmNs1kgb1qj7yP4jQ+dv+4DRkw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.6: view based on sequence  (Enrico Pirozzi <e.pirozzi@nbsgroup.it>)
Responses Re: PostgreSQL 9.6: view based on sequence  (Enrico Pirozzi <e.pirozzi@nbsgroup.it>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Enrico Pirozzi
Date:
Subject: Re: PostgreSQL 9.6: view based on sequence
Next
From: Enrico Pirozzi
Date:
Subject: Re: PostgreSQL 9.6: view based on sequence