Re: PostgreSQL 9.6: view based on sequence

On 1/24/18 06:52, Enrico Pirozzi wrote:
> 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.

There is nothing from with user code using the data type "name". It's
probably just not the best choice. But if you create a view over a
system table, then you'll get whatever types the system table uses.
There is nothing from with that.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services