Re: PostgreSQL 9.6: view based on sequence

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.6: view based on sequence
Date: 2018-01-25 17:07:25
Message-ID: 0bcc6563-cf37-ec1e-feef-53685f13282c@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Kumar 2018-01-25 17:13:19 Postgres and Unix groups
Previous Message Peter Eisentraut 2018-01-25 17:02:39 Re: Postgres for hadoop