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.pirozzi@xxxxxxxxxxx