| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | psql \d sequence display |
| Date: | 2017-09-25 16:11:18 |
| Message-ID: | 97d2a581-5b03-ae5e-5427-1aabdea540e0@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
In PostgreSQL 10, the sequence metadata moved from the sequence
"relation" to a system catalog. The psql \d sequence command was not
updated for that. (It just did SELECT * FROM seq and there were no
tests, so this was missed.) Attached is a patch that fixes that up,
taking the opportunity to design a more useful sequence display that is
not merely hacked on to the general relation display.
This should be fixed for PG10, so if you have any feedback on the
design, please let me know soon.
Examples are in the attached patch.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-psql-Update-d-sequence-display.patch | text/plain | 13.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-09-25 16:13:27 | Re: Server crash due to SIGBUS(Bus Error) when trying to access the memory created using dsm_create(). |
| Previous Message | Robert Haas | 2017-09-25 16:06:19 | Re: CREATE COLLATION does not sanitize ICU's BCP 47 language tags. Should it? |