Re: PostgreSQL 9.6: view based on sequence

> tmp1=# create sequence x;
> CREATE SEQUENCE
> Time: 69,857 ms
> tmp1=# select * from x;
> last_value | log_cnt | is_called
> ------------+---------+-----------
> 1 | 0 | f
> (1 row)
>
> Maybe what you want to do is
>
> create view v_test_sequence as select nextval( 'test_sequence' );
>
> Ciao.

Yes but this appens on a 10.x version :)

Ciao
--

Enrico Pirozzi
e(dot)pirozzi(at)nbsgroup(dot)it