2018-01-24 12:52 GMT+01:00 Enrico Pirozzi <e.pirozzi@xxxxxxxxxxx>: > Hi, I was doing a test on a 9.6 and I've seen a strange thing > > if I run > > create sequence test_sequence; > create view v_test_sequence as select * from test_sequence; > > PostgreSQL creates a view based on the sequence and the strange thing is > that, among the various fields that are created in the view, > there is a field named sequence_name with datatype name. > > I've seen in the docs > https://www.postgresql.org/docs/9.6/static/datatype-character.html > and the datatype name should be reserved only for structures internal of PG. > > Does anyone help me? > > Enrico > > > > -- > Enrico Pirozzi > e.pirozzi@xxxxxxxxxxx > > 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. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS
