| From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
|---|---|
| To: | Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)it> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.6: view based on sequence |
| Date: | 2018-01-24 14:02:18 |
| Message-ID: | CAHjZ2x4H7v3KhPFn2v1j4KZDJmNs1kgb1qj7yP4jQ+dv+4DRkw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2018-01-24 14:52 GMT+01:00 Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)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(dot)pirozzi(at)nbsgroup(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Enrico Pirozzi | 2018-01-24 14:38:23 | Re: PostgreSQL 9.6: view based on sequence |
| Previous Message | Enrico Pirozzi | 2018-01-24 13:52:22 | Re: PostgreSQL 9.6: view based on sequence |