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
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 |